| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
CAN YOU HELP WITH A FORMULA?
Brilliant! Sorted! Thanks for your help.....
-- MARY "Naveen" wrote: Try this ... =IF(J2<TODAY(),"OK",IF(J2=TODAY(),"DO",IF(J2TODAY (),"DO"))) Please rate me. "Mary Mace" wrote: I am trying to ascertain from a list of dates which items need to be done. Have used the "If" function and embedded the "TODAY" formula within that. I have tried this several ways, but cannot get it to work properly. The formula I have at the moment is =IF(J2<"TODAY","OK",IF(J2="TODAY","DO",IF(J2"TODA Y","DO"))), but whether or not the date is before, after or on today, I get the same answer of "DO." Can you tell me where I'm going wrong? -- MARY |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Threaded Mode
