Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need a formula to determine if date falls within a date range then
Help.
Cell A1 = 16/1/08 Cell A2 = 1/1/08 Cell A3 = 28/1/08 Formula needed for Cell A4 I would like a formula for: Cell A4= if A1 =A2 and <=A3 them retuen X appreciate the help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need a formula to determine if date falls within a date range then
Try,
=IF(AND(A1=A2,A1<=A3),"x","") Mike "Corca" wrote: Help. Cell A1 = 16/1/08 Cell A2 = 1/1/08 Cell A3 = 28/1/08 Formula needed for Cell A4 I would like a formula for: Cell A4= if A1 =A2 and <=A3 them retuen X appreciate the help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need a formula to determine if date falls within a date range then
Hi,
If(and(A1=A2,A2<=A3),"X","whatever") -- Regards, Ashsih Mathur Microsoft Excel MVP www.ashishmathur.com "Corca" wrote in message ... Help. Cell A1 = 16/1/08 Cell A2 = 1/1/08 Cell A3 = 28/1/08 Formula needed for Cell A4 I would like a formula for: Cell A4= if A1 =A2 and <=A3 them retuen X appreciate the help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If date in cell falls between date range... | Excel Worksheet Functions | |||
Need true or false if a date falls between a date range | Excel Worksheet Functions | |||
Return a specified date when it falls within a range.... | Excel Discussion (Misc queries) | |||
Can I check if a date falls between a range then sum other # if tr | Excel Worksheet Functions | |||
Formula to determine whether number falls within range?? | Excel Worksheet Functions |