Calculating next due date

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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)

Ida H said:
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
Click to expand...
from the date of their last physical.
If someone is age 39 or younger they need a new physical in 3 years or
Click to expand...
less from the date of their last physical.
If I list names, age and date of current physical I would like to
Click to expand...
calculate the next due date 2 or 3 years later based on age.
 
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
Click to expand...
2 years or less from the date of their last physical.
If someone is age 39 or younger they need a new physical
Click to expand...
in 3 years or less from the date of their last physical.
If I list names, age and date of current physical I would
Click to expand...
like to calculate the next due date 2 or 3 years later
based on age.
 
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.
Click to expand...

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
 
Back
Top