days and dates - ajit

A

Ajit Munj

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
 
B

Bob Phillips

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)
 
Top