ExcelBanter - Need a formula to determine if date falls within a date range then

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Need a formula to determine if date falls within a date range then (https://www.excelbanter.com/excel-worksheet-functions/203126-need-formula-determine-if-date-falls-within-date-range-then.html)

Corca

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.

Mike H

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.

Ashish Mathur[_2_]

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.

All times are GMT +1. The time now is 06:00 PM.