| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Function - Date evaluation
I want another cell to evaluate if there is a date (of any kind) in another
cell. If there is then I want the formula to place the date minus 30 days. If there's not, then I want it to say "NA". Ex: Cell A4 can have, "OK", "Overdue", or physically input a date. Cell A5 will be A4-30, if there is a date. If there is not then A5 will read "NA". Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Electronic Evaluation/Feedback Forms in Excel | Excel Discussion (Misc queries) | |||
| Continuous Evaluation of Time Function NOW() ?? | Excel Worksheet Functions | |||
| Vlookup evaluation | Excel Worksheet Functions | |||
| Automatic evaluation of custom worksheet function | Excel Worksheet Functions | |||
| Options Evaluation | Excel Worksheet Functions | |||
Threaded Mode
