Thread: Using '=MIN(DATE(YEAR(A1),MONTH(A1)+{7,6},DAY(A1)*{0,1}))'
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dav
 
Posts: n/a
Default Using '=MIN(DATE(YEAR(A1),MONTH(A1)+{7,6},DAY(A1)*{0,1}) )'

The easy option is to add a number of days onto the date. However this
will not be an exact number of months. The Function used can be
modified to add a number of months, I can do this for you but need to
know what you would do if x months in the future the date did not
exist, for example 31st february can not exist, would you be hapy for
this to be the 1st of the next month?

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=506773

Reply With QuoteReply With Quote