View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default formula to return 1st of the month following 60 days

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


"Jessica" wrote:

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!