The date should be based on an employee's hire and birth date. If the
employee is over age 21 and has worked more than one year, the employee's
date should be either 1/1 or 7/1 following the requirements. The date should
also include the correct year when the person will meet the age 21 and after
one year of employment. Does this help?

"Dave F" wrote:

Excel can calculate dates.

It's not clear, though, from your description what you need to do. Please
provide more details about how you want to calculate dates, and someone will
come up with a solution. There are simply too many methods to date
calculation in Excel to reliably respond to your post with the information
provided.

Dave
--
Brevity is the soul of wit.


"laura" wrote:

I am working on a project that requires that I calculate dates. The problem
is that the formula must calculate specific dates (1/1 and 7/1) with the
correct year. Can anyone tell me the best way to handle this other than
using another program?

Thanks!