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