check if a a date is in a specified daterange

H

H. Nissen

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:)
 
S

Sheeloo

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

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

H. Nissen

Just what I needed, thank you very much :)

Sheeloo said:
=AND((A2>E2),(A2<F2))
will give you TRUE or FALSE...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top