Hi again,
This RIDICULOUSLY long (and somewhat hard to follow) formula should do the trick for any leave within 1 month, crossing over two months (e.g. Feb-Mar), or crossing over 3 months (e.g. Feb-Apr). It should even handle when your dates go from one year to the next (e.g. Dec '09-Jan '10). If you have any leave longer than that someone's going to have to come up with a better formula (or use a macro)!
First, I changed the month names in C1:N1 to actual text, not dates. "Jan", "Feb", "Mar", etc. (all 3 characters) through "Dec".
In C2 I entered the formula:
Then fill that formula right to cell N2. Select C2:N2 and fill the formula down as many rows as you need.
Hopefully that helps!!
Bookmarks