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