| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Dates in Formula
I want to create an IF statement that says if a cell value is equal to a set
date then "True" otherwise "False" The formula used is: =IF(A12="01/04/2004", "TRUE", "FALSE") The value in A12 is 01/04/2004 (created by formatting cell to dd/mm/yyyy) This returns "False" regardless of what I put in A12 I am using Excel 2000 on an XP Pro O/S. Any help greatly appreciated. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
| How do I format dates accessed by a formula | Excel Discussion (Misc queries) | |||
| Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
| how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
| Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
Threaded Mode
