If a date doesn't equal to
This tutorial shows how to test if a date doesn't equal to another date and return a value if the test is True or False through the use of an Excel formula, with the IF function
|
=IF(B8<>$C$5,"Include","Exclude")
=IF(B10<>$C$5,$C$6,$C$7)
|
GENERIC FORMULA
=IF(date<>spec_date,value_if_true,value_if_false)
ARGUMENTS GENERIC FORMULA
=IF(date<>spec_date,value_if_true,value_if_false)
ARGUMENTS EXPLANATION This formula uses the IF function to test if a date doesn't equal to another date and return a value if the test is True or False.
Click on either the Hard Coded or Cell Reference button to view the formula that has the return values directly entered into the formula or referenced to specific cells.
In this example the formula identifies if a date doesn't equal to another date through the use of a greater and less than signs (<>). Out of the three dates that we are testing two of them are not equal to the specific date and therefore the formula will return a text value of "Include". For the date that is equal to the specific date the formula will return a text value of "Exclude". |
| Related Topic | Description | Related Topic and Description |
|---|---|---|
| If a date is equal to | How to test if a date is equal to another date and return a value if the test is True or False | |
| If a date is less than or equal to | How to test if a date is less than or equal to another date and return a value if the test is True or False | |
| If a date is greater than or equal to | How to test if a date is greater than or equal to another date and return a value if the test is True or False |
| Related Functions | Description | Related Functions and Description |
|---|---|---|
| IF Function | The Excel IF function performs a test on specified conditions entered into the formula and returns a specified value if the result is TRUE or another specified value if the result is FALSE |