Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statement
I am trying to create an if statement with dates. Basically, in one cell the
user will enter either fiscal year 2007, 2008 or 2009. Then when they enter a date range, I want the if statement to verify that the range does in fact fall within the fiscal year they typed in. So basically: If---cell C2=2009 Then---cell D8...this is where I get lost. How do you say you need cell D8 to fall within July 1, 2008 and June 30, 2009? Otherwise---FALSE Thank you very much for your help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statement
Use
=IF(AND(D8DATE(C2-1,7,1),D8<DATE(C2,6,30)),TRUE) This will tell you whether D8 is within the FISCAL year (TRUE) or not (FALSE) "ajr81" wrote: I am trying to create an if statement with dates. Basically, in one cell the user will enter either fiscal year 2007, 2008 or 2009. Then when they enter a date range, I want the if statement to verify that the range does in fact fall within the fiscal year they typed in. So basically: If---cell C2=2009 Then---cell D8...this is where I get lost. How do you say you need cell D8 to fall within July 1, 2008 and June 30, 2009? Otherwise---FALSE Thank you very much for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
If statement or lookup statement not sure | Excel Worksheet Functions | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
If statement and Isblank statement | Excel Worksheet Functions | |||
Help please, IF statement/SUMIF statement | Excel Worksheet Functions |