Thread: Date arithmetic: adding 1 month to prior end of month date
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SteveG SteveG is offline
external usenet poster
  
Posts: 1
Default Date arithmetic: adding 1 month to prior end of month date

manxman,

You could use,

=EOMONTH(A1,1)

Where A1 = your start date. You need the Analysis ToolPak installed to
use the EOMONTH function. Tools, AddIns, select Analysis ToolPak and
click OK.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=561577

Reply With QuoteReply With Quote