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 columns to be populated with the number of days that project was active during 2012 ( 334 days ) 2013&2014 ( 365 days each) ; 2015 ( 119 days ). Something like in the below screenshot. Which is the most suitable formula to do it?
Many thanks!
7 Replies
Your calculations are not quite correct. For example, in 2015, January 1 to April 30 is 31+28+31+30=120 days.
See the attached workbook.
This is super helpful...thank you! I'd like to have the worksheet count days in the total and per calendar year if the project end date is empty. Can you modify your file to deal with that?
Edit: For the Total, it should be =IF(ISBLANK(C3),(TODAY()-B3)+1,C3-B3+1), but having difficulty with the year by year amounts.
Thanks in advance!
See the attached version.
- Many thanks Hans for your answer, really helpful.
One more thing:
If I want to settle a calendar different from the natural calendar. For instance, I want that everything from June 1, 2010 to May 31, 2011 falls under "Period2010"; June 1, 2011 to May 31, 2012 -> "Period 2011" ... ? May I mannually change that?
Thanks again!See the attached modified version.
