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 No comments
{count} votes

2 answers

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

    Hi,

    Ending date cell - beginning date cell

    0 comments No comments

  2. Q&A Assist
    2026-02-17T22:58:13.0633333+00:00
    AI generated content. This question contains an answer created with AI from Q&A Assist. Learn more

    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:

    0 comments No comments

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.