formula to return 1st of the month following 60 days

  • Thread starter Thread starter Jessica
  • Start date Start date
J

Jessica

Hello -

I need, please, a formula to return the following. So, if someone started
working with us on 10/15/09, the 1st of the month following 60 days of
employment would be 1/1/10. That's what I need.

THANK YOU!
 
What about 1st of a month say 10/1/2009

'If you expect 1/1/10 then use
=DATE(YEAR(A1),MONTH(A1)+3,0)+1

'if you expect 12/1/09 then use the below version
=DATE(YEAR(A1-1),MONTH(A1-1)+3,0)+1

Regards

Jacob
 
=DATE(YEAR(A1+60),MONTH(A1+60)+1,1)

or (if you have Analysis ToolPak installed) =EOMONTH(A1+60,0)+1
 
Back
Top