| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula including dates
On an Excel spreadsheet, I have numerous columns with dates. How do I write
the formula so that if the dates in Column I OR Column L are before today's date, it will default to "x" in column C? If the dates in BOTH columns are after today's date, I want it to default to "a" in column C. Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| dates formula | Excel Worksheet Functions | |||
| How can I create a formula to locate data between two dates? | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| revert formula insertion to old method | Setting up and Configuration of Excel | |||
| How do I format dates accessed by a formula | Excel Discussion (Misc queries) | |||
Threaded Mode
