I'm a newbee to this board. I'm entering enter a date (October 1, 2002) in say A1. then, starting in A2 through A362, I want to have each row display the next month. Currently, I am using a formula to add 31 to previous field (formular for A3= "=a2+31", A4= "A3+31" and so on. That doesn't work each time because some months have 30,31,28 days. By the time I get to the the fifth year, It starts to skip a month approximately every five years. How can I do this accurately? Thanks,
Latete
Latete