| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using dates in IF statements
Works perfectly
Thanks much "joeu2004" wrote: On Jul 15, 2:08 pm, altah wrote: I need to create a statement with the following criteria and response. Please help. [....] If 7/15/07 1/2/02 + 5 years, then 5, otherwise 3.33 Does this do what you want? =if(today() date(5+year(A1), month(A1), day(A1)), 5, 3.33) where today() and A1 replace what you wrote as 7/15/07 and 1/2/02 respectively. Note the difference between that and the following: =if(datedif(A1, today(), "y") 5, 5, 3.33) You decide which meets your intentions better. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF statements with Dates | Excel Discussion (Misc queries) | |||
| If Statements with Dates | Excel Discussion (Misc queries) | |||
| If statements and Dates | New Users to Excel | |||
| Dates in IF statements | Excel Discussion (Misc queries) | |||
| if statements & dates? | Excel Worksheet Functions | |||
Threaded Mode
