Link to home
Start Free TrialLog in
Avatar of Larry Brister
Larry BristerFlag for United States of America

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
Avatar of Bill Prew
Bill Prew

Do you want the calculated number of days between the two dates, or a text string that has the start and end dates?

Avatar of Bill Prew
Bill Prew

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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")