I want excel to fill the days and dates automatically
when I change the month in cell a1 for me. How can I do so?
ajit

--
Knowldege is Power

A1: the nominated month as text, say May

C1: =DATEVALUE("01-"&A1&"-"&YEAR(TODAY()))
C2: =IF(OR(C1="",MONTH(C1+1)<>MONTH(C1)),"",C1+1)

and copy C2 down

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Ajit Munj" <(E-Mail Removed)> wrote in message
news:EAA4AC28-30C1-4859-8EAF-(E-Mail Removed)...
>I want excel to fill the days and dates automatically
> when I change the month in cell a1 for me. How can I do so?
> ajit
>
> --
> Knowldege is Power