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 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!
- 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.
4 Replies
- 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.
