From date to date

Copper Contributor

how can I enter a From date to a date in one cell in excel?

1 Reply

@ZalmenG 

Let's say the start date is in A2 and the end date in B2.

The formula

 

=TEXT(A2,"mmmm d")&" - "&TEXT(B2,"mmmm d")

 

will return the date range looking like this:

 

February 28 - March 10

 

You can use another date format of course, and change the way the range is presented. For example

 

="From "&TEXT(A2,"m/d/yyyy")&" to "&TEXT(B2,"m/d/yyyy")

 

will return the date range looking like

 

From 2/28/2021 to 3/10/2021