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...
The meaning of the subtraction is: it is 3 days from the 5th to the 8th: 5 to 6, 6 to 7, 7 to 8.
If you want to count the number of days "in between" (excluding the start date and end date), use
=MAX(enddate-startdate-1, 0)