check if a a date is in a specified daterange
 

I need to check if a date is within a specified date range, then C4 may
return true or false

C D E F
2 12-04-2008 01-03-2008 01-05-2008
3
4 if C2 is between E2 and F2 = true else = false

Is there someone who can help me to make the code function that can handle
this small matter:)

check if a a date is in a specified daterange
 

=AND((A2E2),(A2<F2))
will give you TRUE or FALSE...

You can put an IF around it
=IF(AND((A2E2),(A2<F2)),"Value if TRUE","Value if FALSE")


"H. Nissen" wrote:

I need to check if a date is within a specified date range, then C4 may
return true or false

C D E F
2 12-04-2008 01-03-2008 01-05-2008
3
4 if C2 is between E2 and F2 = true else = false

Is there someone who can help me to make the code function that can handle
this small matter:)

check if a a date is in a specified daterange
 

=AND(C2=E2,C2<=F2)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"H. Nissen" wrote in message
...
I need to check if a date is within a specified date range, then C4 may
return true or false

C D E F
2 12-04-2008 01-03-2008 01-05-2008
3
4 if C2 is between E2 and F2 = true else = false

Is there someone who can help me to make the code function that can handle
this small matter:)

check if a a date is in a specified daterange
 

Just what I needed, thank you very much :)

"Sheeloo" wrote:

=AND((A2E2),(A2<F2))
will give you TRUE or FALSE...

You can put an IF around it
=IF(AND((A2E2),(A2<F2)),"Value if TRUE","Value if FALSE")


"H. Nissen" wrote:

I need to check if a date is within a specified date range, then C4 may
return true or false

C D E F
2 12-04-2008 01-03-2008 01-05-2008
3
4 if C2 is between E2 and F2 = true else = false

Is there someone who can help me to make the code function that can handle
this small matter:)

check if a a date is in a specified daterange
 

Another one...

Assuming "between" means inclusive:

=C2=MEDIAN(C2,E2:F2)

--
Biff
Microsoft Excel MVP


"H. Nissen" wrote in message
...
I need to check if a date is within a specified date range, then C4 may
return true or false

C D E F
2 12-04-2008 01-03-2008 01-05-2008
3
4 if C2 is between E2 and F2 = true else = false

Is there someone who can help me to make the code function that can handle
this small matter:)