Hi
The solution needs to cover a range of dates, not just May. My approach was that if I had the solution for May I could use the same formula for other months.
For example I will have a range of dates from Feb 16 to Dec 17 and I need to calculate the number of days within each date range for each month.
Hope this makes sense.
Thanks
Tony