Date Function

[Chatbot]

I have cell A1 where I would input month name (Jan'11-Dec'11) and have a column where we all the dates in the month, so what I m looking at is if somebody updates the month name, dates automatically get changed.

For eg:

If A1 = Jan'11

01/01/2011
01/02/2011
01/03/2011 and so on

Similarly, A1 = Feb'11

02/01/2011
02/02/2011
02/03/2011 and so on

Please share your feedback