Dates ... advance 1 Month @ a Time

[Guest]

Excel2003 ... I want to enter 01/01/07 in Cell A1 and then have Range B1:L11
values be 02/01/07, 03/01/07, 04/01/07 etc etc ... After this I will chg my
format to suit.

How do I properly write this Date formula ... Thanks ... Kha

 

[Bernard Liengme]

=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))
best wishes

 

[Guest]

. ... or put first two dates in A1 & B1, highlight and drag across to L1

 

[Guest]

Actually ... EDATE(A1,1) ... got me there ...

Initially, I was trying formulas similar to Bernards & I was failing ...
However, these clarifications will come in handy ... Thanks for the guidance
.... Kha