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? |
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 |