Get total number of days per month
This was a question from one of my friends, This set of formulas will calculate how many days (Networkdays) in each of the months in the list for a given Start and End dates

If Range of dates are across multiple years, user can copy columns C, D, E and F to fill those years

The months for the list are automatically populated starting from Jan of the year of the start date

The main formula in F7 should be:

=IF(OR($D$2>E7,$D$3<D7),"",
NETWORKDAYS(IF(D7>$D$2,D7,$D$2),IF(E7<$D$3,E7,$D$3)))

 

Comments

comments