If you have a date in cell A1:
=DATE(YEAR(A1),MONTH(A1)+1,1)
This one requires the Analysis ToolPak add-in be installed for Excel
versions prior to Excel 2007:
=EOMONTH(A1,0)+1
Format as Date
--
Biff
Microsoft Excel MVP
"Linda M" <Linda
wrote in message
...
I am trying to develope a worksheet that gives me the eligiblity date of an
employee (i.e. 1st of the month after 60 days).