Hi All,
I have a list of events with start date and end dates (sometimes these are single day events) but I need to know how many working days appear in a certain month.
For example someone has taken a holiday from the 29th of January to the 5th of February 2021 this is 6 working days but only 5 of those are in February.
Is there a formula I can apply that will take the start date and end date of the event then calculate how many working days in that range are from each month (so in the above example it would give me 1 for Jan, 5 for Feb, 0 for Mar etc.)?
Thanks in advance (please ask if my question doesn't make sense)
Gav
I have a list of events with start date and end dates (sometimes these are single day events) but I need to know how many working days appear in a certain month.
For example someone has taken a holiday from the 29th of January to the 5th of February 2021 this is 6 working days but only 5 of those are in February.
Is there a formula I can apply that will take the start date and end date of the event then calculate how many working days in that range are from each month (so in the above example it would give me 1 for Jan, 5 for Feb, 0 for Mar etc.)?
Thanks in advance (please ask if my question doesn't make sense)
Gav