Larry Brister
asked on
Excel Date from to Formula
I have a cell that I need a formula that looks at two other cells
A1 = "04/01/2021"
B1 = "04/15/2021"
My results need to be
Apr 1 - Apr 15
A1 = "04/01/2021"
B1 = "04/15/2021"
My results need to be
Apr 1 - Apr 15
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If both values are strings try this.
=TEXT(DATEVALUE(A1), "mmm d")&"-"&TEXT(DATEVALUE(B1) , "mmm d")
If they are date values try this.
=TEXT(A1, "mmm d")&"-"&TEXT(B1, "mmm d")
=TEXT(DATEVALUE(A1), "mmm d")&"-"&TEXT(DATEVALUE(B1)
If they are date values try this.
=TEXT(A1, "mmm d")&"-"&TEXT(B1, "mmm d")
»bp