Share via

Excel: Days Between Two Dates

Mark_Ta 0 Reputation points
2026-02-17T22:58:01.7+00:00

Hello, I’d like to create a table in Excel with a column that automatically calculates the number of days between two dates. How can I set this up?

Thanks in advance for your help!

Microsoft 365 and Office
Microsoft 365 and Office

A comprehensive suite of productivity tools and cloud services that enhance collaboration, communication, and efficiency. Combining classic Office apps with advanced Microsoft 365 features, it supports both personal and business needs

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ashish Mathur 101.8K Reputation points Volunteer Moderator
    2026-02-17T23:18:48.4033333+00:00

    Hi,

    Ending date cell - beginning date cell

    Was this answer helpful?

    0 comments

  2. AI answer

    2026-02-17T22:58:13.0633333+00:00

    To create a column in Excel that automatically calculates the number of days between two dates, you can use the DAYS function. This function takes two arguments: the end date and the start date. Here’s how you can set it up:

    1. Enter your dates: In two separate columns, enter your start date and end date. For example, you can use column A for the start date and column B for the end date.
    2. Use the DAYS function: In a new column (let's say column C), you can enter the formula to calculate the number of days between the two dates. The formula would look like this: 
         =DAYS(B2, A2)
      Here, B2 is the cell with the end date and A2 is the cell with the start date.
    3. Drag the formula down: If you have multiple rows of dates, you can drag the fill handle (a small square at the bottom-right corner of the cell) down to apply the formula to other rows.

    This will give you the number of days between the two dates in column C.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.