Calculating next due date

[Guest]

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.

 

[Bob Phillips]

Ida,

Assuming age in B, Date of physical in C

=IF(B1>=40,DATE(YEAR(C1)+2,MONTH(B1),DAY(B1)),DATE(YEAR(C1)+3,MONTH(B1),DAY(
B1)))

gives last date

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

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.

 

[Guest]

Hi!
You can try:

=IF(A1>39,lastphysicaldate+730,lastphysicaldate+1095)

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.

 

[Ron Rosenfeld]

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(DateOfCurrentPhysical)+25+12*(Age<40),0)


--ron