Forum Discussion
From date to date
how can I enter a From date to a date in one cell in excel?
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