I would like a formula to tell me the number of days holiday taken this month
I have searched for a formula to calculate the number of days holiday, but I would like it to be more specific to tell me the number of days taken this month.
So far I have this:
=SUMIFS(Duration:Duration, Absence:Absence, "holiday", Assigned:Assigned, "Fred") which tells me the number of days holiday, total. But I need to restrict it to either 2020 or the current month.
The next step on from here to to tell me the number of days worked in a month based on subtracting holiday and sickness from the number of working days in a month. - but I'll settle for the formula above!
Help Article Resources
Check out the Formula Handbook template!