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...
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!
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.