On 9 May, 21:42, N85DZ wrote:
Is there any way to have excel automatically tell me which type of medical I
hold?

Not sure if I've understood your requirements properly, but here's a
solution of sorts.

In cell:

A1 enter date of your last 1st class exam
A2 enter date of your last 2nd class exam
A3 enter date of your last 3rd class exam

B1 enter =A1+180
B2 enter =A2+730
B3 enter =A3+

C1 enter =IF(B1TODAY(),"VALID","EXPIRED")
C2 enter =IF(B2TODAY(),"VALID","EXPIRED")
C3 enter =IF(B3TODAY(),"VALID","EXPIRED")

HTH

Andrew