Excel Formula: Create Date Range From Two Dates

Here lists two dates, the job is to create the date range based on the two dates and connect them with “-“. Here this tutorial provides a formula with TEXT function to solve this job.

If you want to follow along with this tutorial, please download the example spreadsheet.

Generic formula:

Syntaxt and Arguments

Return Value

The formula returns to a text value.

How this formula works

For instance, two dates are in cell B3 and C3, now to create a date range, please use below formula:

Press Enter key to get the date range.

Explanation

TEXT function: converts number to text with a specific format.

If you directly use the “&” in the formula to connect two dates to create a date range, the result will be displayed as 43952-43985 since the date is stored as number in Excel. Now using the TEXT function to convert the number/date to a text string in a specific format (a date format), then concatenate two dates, the result will be seen as a date range.

Relative Formulas

• Check if a date is workday
  This tutorial provides a formula to to check a date if is a workday.
• Check two dates are in the same year month
  To check if two dates in the same year month, you can use the formula in this tutorial.
• Count Days From Today
  This tutorial provides the best formula to calculate the difference between a date and today in Excel.
• Convert Weekday in A Date Range
  If there is a list of dates, how can you count a certain day of week in such a list of dates?

Relative Functions

• Excel WEEKNUM Function
  Returns the week number of the given date in a year
• Excel WORKDAY Function
  Adds workdays to the given start date and returns a workday
• Excel MONTH Function
  The MONTH is used to get the month as integer number (1 to 12) from date
• Excel DAY Function
  DAY function gets the day as a number (1 to 31) from a date
• Excel NOW Function
  Get the current time and date