Hi,

I have date like this
Column A Column B

Jun-2007 30 days
Aug-2007 31 days
Feb-2008 29 days

I used data validation for Column A
If I choose Jun-2007 in the column B I need only June date like
01-jun-07, 02-jun-07 .....................30-jun-07
Similarly for others.

I don't want to create separate date list for jun,jul..... And then use
=indirect function