Date Formula

Question

What is the Formula to count days between two dates

Answer 1

Use one of these common formulas in Excel:

1. Simple subtraction (both cells contain valid dates):

=EndDateCell - StartDateCell

Example:

=C2 - B2

This returns the number of days between the two dates.

2. Using the DAYS function:

=DAYS(EndDateCell, StartDateCell)

Example:

=DAYS(C2, B2)

This also returns the number of days between the two dates.

---

References:

• Subtract dates in Excel for Mac
• DAYS function
• Calculate the difference between two dates
• Examples of common formulas in lists
• Calculate age