| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using if statements with a date
It was an oversight, I didn't notice that the OP wants 2 on the TRUE branch.
Sorry for the late answer but I've just now realized that my e-mail notification doesn't work. -- Regards! Stefi David Biddulph ezt *rta: I think Stefi may have intended to say =(A2=DATE(2005,1,1))*2 -- David Biddulph "Stefi" wrote in message ... dates being in A2, A3, ... =--(A2=DATE(2005,1,1)) Regards, Stefi "Stonsey" ezt *rta: Hia I want to use a formula which will return a 0, if the date is on or prior to 31 Dec 2004 and a 2 if date entered is on or after 1 January 2005 - Would love some help on how to do this Thanks . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF and THEN statements | Excel Discussion (Misc queries) | |||
| IF statements with more than one date column | Excel Worksheet Functions | |||
| If, Then Statements | Excel Worksheet Functions | |||
| If, Then Statements | Excel Worksheet Functions | |||
| IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
Threaded Mode
