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.
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).