Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm putting together a spreadsheet showing personnel recurring training dates
and whether they are overdue or current in that training. I have about 100 people with about 50 different training requirements that are recurring on different timelines (ex: Mark Smith has to take CPR class every 20 months and a driving course every 12 months). I'm trying to develop a function/format combo that lets me type in the date they last had that training, paired with the required frequency of the training, giving me a result of "CURRENT" or "OVERDUE" and turning the cell green or red. I've played around with the TODAY() function a little bit, but I can't seem to figure anything out. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
formatting a sentence with functions | Excel Worksheet Functions | |||
Conditional formatting/functions | Excel Discussion (Misc queries) | |||
Formatting text within functions | Excel Worksheet Functions | |||
Functions and formatting | Excel Discussion (Misc queries) | |||
Formatting in IF Functions | Excel Worksheet Functions |