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!

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!

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!

PS

Please make sure that you test it thoroughly before you rely on it.

It may not be correct and there might be some situations where it will
return the wrong date.

Thanks,

Conan




"Conan Kelly" wrote in message
...
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!

I will definitely test it. Thanks!

"Conan Kelly" wrote:

PS

Please make sure that you test it thoroughly before you rely on it.

It may not be correct and there might be some situations where it will
return the wrong date.

Thanks,

Conan




"Conan Kelly" wrote in message
...
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!