Monthly payment cells

[~Jeff~]

If I have a starting cell equal to say: 8/1/2004

I would like each cell under that one to show the 1st of the next month. If
I change the starting cell, the rest will update. How do I do this since not
every month has the same number of days?

Thanks

 

[Frank Kabel]

Hi
enter the following in A2
=DATE(YEAR(A1),MONTH(A1)+1,1)
and copy this down

 

[Dave R.]

You can try

=EDATE(A1,1) to add a month.