Thread: Round up month
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bpeltzer
 
Posts: n/a
Default Round up month

If you ALWAYS need to go to the first of the following month,
=date(year(today()+60),month(today()+60)+1,1). If that 60-day wait winds up
on the 1st and you then DON'T need to wait for the first of the following
month, make it conditional:
=if(day(today()+60)=1,today()+60,date(year(today() +60),month(today()+60)+1,1)).

"Edfermo" wrote:


How do I calculate the "the 1st day of the month following 60 (or any
number of days) days"


--
Edfermo
------------------------------------------------------------------------
Edfermo's Profile: http://www.excelforum.com/member.php...o&userid=29231
View this thread: http://www.excelforum.com/showthread...hreadid=489547