formula to return 1st of the month following 60 days

[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!

 

[Jacob Skaria]

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

 

[T. Valko]

Try this...

A1 = some date

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

 

[David Biddulph]

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

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