Originally Posted by
daddylonglegs
Yes, there 86 dates in the list but not 86 different dates. As my formulas show 15 dates were shown twice,
15*2+56*1 = 86
There are 228 dates between 8th April and 21st November if you count both start date and end date, which you need to do as you have operations on those dates. The correct formula to count dates, including start and end, would be
=F2-F1+1
Otherwise if there was only 1 date on the list, for instance, then F2 would be the same as F1 and F2-F1 would give zero.
Bookmarks