LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jermsalerms
 
Posts: n/a
Default Formula = Today's date + 1 month


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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to get 1st,2nd,3rd,4th,5th Sundays from month end date. mikeburg Excel Discussion (Misc queries) 5 September 29th 05 06:59 PM
Setting traffic lights based on todays date against target dates HDV Excel Discussion (Misc queries) 2 September 14th 05 12:05 PM
Formula for Extracting Month out of a Date column PokerZan Excel Discussion (Misc queries) 3 June 10th 05 08:30 PM
What formula converts date to month only [email protected] Excel Discussion (Misc queries) 1 May 16th 05 02:02 PM
Month Year Date Format Jamie Excel Worksheet Functions 2 February 7th 05 06:43 PM


All times are GMT +1. The time now is 01:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"