Hi Rick,
The formula works well for most dates except the ones on the second day of
the month (i.e., 5/2/07, 6/2/07, 7/02/07) because it gives you back their own
value. What do you think?

"Rick Rothstein (MVP - VB)" wrote:

Employees are eligible for benefits the first day of the month after 60
days
of work. Example: An employee starts working today 6/26/07; her benefits
are effective September 1st., which is the first day of the month after 60
days of work. What formula I can use to come up with the effective date
for
benefits?

Assuming if 60 days hence ends up on the first of the month, you use that
date...

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

Change the A1 reference to the cell where your date is.

Rick