Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select criteria based on date
I am a pilot. I am using Excel to create a digital logbook to keep track of
everything for me. I am looking for a way to have excel tell me what class of medical I currently hold. Pilot medicals come in three types first class, second class, and third class. First class is active for 6 months after examination, second class is active for 2 years after examination (1yr 6months after first expires), and third class is active for 3 years after examination (2yrs 6months after first expires, 1yr after second expires). Is there any way to have excel automatically tell me which type of medical I hold? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select criteria based on date
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select criteria based on date
Not quite what I am looking for, thank you though. I want it to return First, Second, or Third in one cell. Also, I think the dates should be something like, (exam on 1/4/07) 1/4/07 to 6/31/07 - return first 7/1/07 to 1/31/09 - return second 2/1/09 to 1/31/10 - return third |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Result Based on Date Criteria | Excel Discussion (Misc queries) | |||
Select rows based on criteria | Excel Worksheet Functions | |||
data validation list should have opt. to select based on criteria | Excel Worksheet Functions | |||
date criteria to select range | Excel Worksheet Functions | |||
Can I select a worksheet based upon a cell criteria?(for printing) | Excel Worksheet Functions |