Calculating next due date

Hi!
You can try:

=IF(A139,lastphysicaldate+730,lastphysicaldate+10 95)

where A1 is the age. (730 and 1095 are two and three years
in days, respectively. There are better ways to do this
but I think this is the fastest and dirtiest.)

Hope this helps -
Eliezer

-----Original Message-----
I need help in calculating the next date an aviation
physical is due.

If someone is age 40 or older they need a new physical in
2 years or less from the date of their last physical.
If someone is age 39 or younger they need a new physical
in 3 years or less from the date of their last physical.

If I list names, age and date of current physical I would
like to calculate the next due date 2 or 3 years later
based on age.
.

On Tue, 3 Feb 2004 15:11:08 -0800, "Ida H"
wrote:

I need help in calculating the next date an aviation physical is due.

If someone is age 40 or older they need a new physical in 2 years or less from the date of their last physical.
If someone is age 39 or younger they need a new physical in 3 years or less from the date of their last physical.

If I list names, age and date of current physical I would like to calculate the next due date 2 or 3 years later based on age.

It's not really two (or three) years or less.

It expires at the end of:

(A) The 36th month after the month of the date of the examination shown on the
certificate if the person has not reached his or her 40th birthday on or before
the date of examination; or

(B) The 24th month after the month of the date of the examination shown on the
certificate if the person has reached his or her 40th birthday on or before the
date of the examination.

So the formula would be:

=DATE(YEAR(DateOfCurrentPhysical),MONTH(DateOfCurr entPhysical)+25+12*(Age40),0)


--ron