Forum Discussion
Counting the number of days of a project during each year
Hi all, I need a formula that brings me the number of days of each year where a project was active. For instance, if a project starts on February1, 2012, and finishes on April 30, 2015, I want co...
See the attached version.
Thank you for the quick response! Posting this for others looking at this:
I didn't need the prior users need to accommodate strange start and end date of years (he wanted the year specified as 6/1 - 5/31). The version you attached kept that. Switching the formula in cell F3 to:
=MAX(MIN(DATE(F$2,12,31),IF($C3="",TODAY(),$C3))-MAX(DATE(F$2,1,1),$B3)+1,0)
and copying to the other cells got it back to the "normal" 1/1 - 12/31 calendar year cycle.
