Laura,

I created a sample worksheet with formulas in it that should accomplish what
I *THINK* you are trying to do.

It may be possible to create one formula to do all this in one cell, but I
think that it would be *VERY* long and complicated. I think that it will be
easier to understand how I have done it he
http://home.att.net/~ctbarbarin/date_problem.xls

I used a couple of "helper" columns along with the Hire Date & Birthdate
columns: 1 Year Employment Anniversary, 21st Birthday, Max of the 2 days,
and then the last column is what I think you are looking for.

Please let me know if you have any questions.

I hope this helps,

Conan Kelly





"laura" wrote in message
...
Any news on an answer???

"laura" wrote:

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!