Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I write an IF function using dates?
I'm trying to do a logical test that uses dates. If I use it returns the
correct result, but if I use = or < I get the wrong result: A B C 1 25/03/2010 500 0 2 24/03/2010 300 0 3 27/03/2010 750 750 In C1 the formula is =IF(A1=25/3/2010,K32,0) which I would expect to be true and return 500, but it returns the false value In C2 the formula is =IF(A2<25/3/2010,K33,0) which I would expect to be true and return 300, but it returns the false value In C3 the formula is =IF(A325/3/2010,K34,0) which is true and returns the correct value. Can anyone help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I write an If(And( function using dates as my logical test? | Excel Worksheet Functions | |||
How to write a macro to count dates | Excel Worksheet Functions | |||
Write Holidays between two dates? | Excel Worksheet Functions | |||
how do I write a vlookup function within an iserror function so t. | Excel Worksheet Functions | |||
How do I write a formula to color code based on dates provided or. | Excel Worksheet Functions |