SOLVED

Calculate the numbers of days from date to date.

Copper Contributor

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.

 

Thank you in Advance!

4 Replies
best response confirmed by OffMng (Copper Contributor)
Solution
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.

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

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.
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).
1 best response

Accepted Solutions
best response confirmed by OffMng (Copper Contributor)
Solution
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.

View solution in original post