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. |
#2
|
|||
|
|||
Have a look in HELP index for using IF in a formula
-- Don Guillett SalesAid Software "R L Sandel" <R L wrote in message ... 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. |
#3
|
|||
|
|||
What if the dates are today's date?
If "a": C1: =IF(AND(I1=TODAY(),L1=TODAY()),"a","x") If "x": change = to In article , "R L Sandel" <R L wrote: 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. |
Reply |
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) |