 SOLVED

Highlighted

# Calculate the numbers of days from date to date.

Hello,

I am needing help calculating between two dates. I'm using the =DAY(end_date, start_date), however, I need the end and start dates to be included in the day count.

For example, If our start day is on 7/01 and our end day is on 7/24. Using the above formula gives me 23 days, however the job lasted 24 days because 7/01 was the first day on the job and 7/24 was the last day on the job. I wondered if there was a easier way for me to calculate this, or if I needed to just put a +1 after my formula.

4 Replies
Highlighted
Solution

# Re: Calculate the numbers of days from date to date.

In law and accounting, the start date is excluded, and the end date is included. So is Excel, such that you simply have to add 1, as you correctly suggested, to include both in the number of days.
Highlighted

# Re: Calculate the numbers of days from date to date.

@Twifoo Thank you for your help! I will add one to my formula.

Highlighted

# Re: Calculate the numbers of days from date to date.

You’re welcome. Beware that the addition of 1 is limited only to satisfy your requirement. Other than your requirement, the addition of 1 is precluded.
Highlighted

# Re: Calculate the numbers of days from date to date.

The inclusion of Start Date and End Date is commonly used in utility billing; I.E. all days the service is provided are included in the bill. As such, including, both, Start and End dates is not an uncommon need.

With such a common need it is surprising that Excel does not provide a cell function for this purpose (without having to modify an existing cell function).