|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
Date arithmetic: adding 1 month to prior end of month date
That does it. Thanks very much.
"SteveG" wrote:
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
|