Apologies if this has been covered already, but could not find anything when browsed.
Attachment cols B - C list eight hiring periods, some of which span more than one month.
Need a formula covering the whole range that combines four criteria to calculate the number of Hire Days in a month (March in the example):
Hire Days ending in the month, where the hire started in a previous month
Hire Days ending in the month, where the hire started that month
Hire Days running beyond that month, where the hire started in a previous month
Hire Days running beyond that month, where the hire started in that month
Cols F - K show the total should be 107 Hire Days for March.
Hope someone can see the wood for the trees?
Ochimus
Bookmarks