Excel: Days Between Two Dates

Question

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!

Answer 1

Hi,

Ending date cell - beginning date cell

Answer 2

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:

• Excel.Functions class
• What's new in Excel JavaScript API 1.2
• Call built-in Excel worksheet functions
• Functions syntax