You would need to parse the string entry and convert each half to the
respective date. then it should know about May and June.

--
Regards,
Tom Ogilvy

wrote in message
oups.com...
Can I get excel to recognize that the range April 05 to July 05 also
includes May and June?

I am trying to create a macro that populates a range of dates. I am
making a project allocation tool that will involve an input sheet and a
seperate sheet for each month.

I want it so that if you enter a range of dates (ex. 4/05-9/05)the
project will eventually appear in every sheet in its range.



Thanks for your help