Thanks for taking the time with the IF formulas, I appreciate that, but I need the formula to look at the whole range as there are start and end dates dotted among the columns that could include the date in column E and I need to count them all and enter the number next to each date in column E....
...and yeah the start date should be after or equal to the date in column E, and the end date should be less than or equal to the date in column E. I need it to look down the whole B and C columns to see what of those date ranges have the date in column E included. Column E is a helper column so that I can include all the dates for the year and then try and work out how many projects there are 'in progress' on those dates which I was trying to complete with a formula.
I can see that the times that are included in the dates in columns B and C are going to be a problem though, luckily I just found some VBA code to remove the times from the dates from here:
That will save me a bit of time on the master file tomorrow..
..but yeah I need to know how many projects there are that are in progress on each day of the year until the end of next January