Forum Discussion
Solved
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...
- 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.
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.
- 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).
