Hi
I have a very large number of events, by row, which have a start date, and an end date.
And I have a separate table with months as the headers (Jan-21, Feb-21, etc, through to Dec-22)
What I'm wanting Excel to return is the number of working days under each month, for each of the events, if they were "active" for even part of any of those months.
Example:
Start Date 01/01/2021, End Date 31/05/2021.
So, I want it to return 20 for January, 20 for February etc.
Do you have any ideas on how I can do this? Please help!!
I have a very large number of events, by row, which have a start date, and an end date.
And I have a separate table with months as the headers (Jan-21, Feb-21, etc, through to Dec-22)
What I'm wanting Excel to return is the number of working days under each month, for each of the events, if they were "active" for even part of any of those months.
Example:
Start Date 01/01/2021, End Date 31/05/2021.
So, I want it to return 20 for January, 20 for February etc.
Do you have any ideas on how I can do this? Please help!!