Dates ... advance 1 Month @ a Time

  • Thread starter Thread starter Guest
  • Start date Start date
G

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