You haven't catered for 60 days falling on the 1st of month, you go one too
far then, e.g. 2nd June

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Rick Rothstein (MVP - VB)" wrote in
message ...
You can use this formula...

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

Rick


"NeSchw6G" wrote in message
...
I need help making a formula to use the date in cell F3, add 60 days and
then
find the first of the following month.

i.e. The date given would be 8/21/08 and I would need a formula to
produce
11/1/08

If the 60 days falls on the first of the month, then it should produce
the
same number, as in the date given would be 9/2/08 and 60 days would be
11/1/08 and so it should produce 11/1/08.

Thank you,