Forum Discussion
Days between two dates
Subtracting one date from another is supposed to give the number of days in between. However, taking a simple case, subtracting 3/5/23 from 3/8/23 yields 3 days. However there are actually 2 days, no...
John9210 By default, Excel does not count the start date but it includes the end date. Thus 6-7-8 being three days Others might argue that there are 4 days as they want to include the start date. They have to add 1 to the default result. And if you want to exclude the end date as well you need to deduct 1.
So, understand what Excel gives you and adjust to your own needs.