I need to know (calculate) which month(s) and how many times they are in a given time range.
I have dateStart and dateEnd as field. Out of those two I can generate a ΒΆ list (text) of days between dateStart and dateEnd. Parsing out the first date from that field I can calculate the last day of that month, which gives me the 'first month'. (and how many days between the start date and the end of that month, just in case somebody should ask for it in the future...) The same cluncky logic goes for the last date in the range. Now I have two months...and stuck for the in between part. I'm thinking to use a recursive custom function. The 50 000 limit could not be a problem, there will be never 136 years between dateStart and dateEnd. Any hints how to tackle this one ? TIA
