If A1 =TODAY()
then =DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))
puts you 1 month later
--
Gary's Student


"jermsalerms" wrote:


I am trying to do the following in A1:480


A1 = today's date + 1 month
A2 = A1 + 1 month
A3 = A2 + 1 month
A4 = A3 + 1 month

continue that to cell A480

I know that TODAY() will enter todays date but Im not sure how to get
it to read the + 1 month part.

help...thanks


--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167
View this thread: http://www.excelforum.com/showthread...hreadid=509608