A Ajit Munj Dec 10, 2007 #1 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
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 Dec 10, 2007 #2 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)
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)
