check between 2 dates

[Paul Watkins]

Hi
Is it possible to have excel check a date range from something like a form?
for example: I have various data entries on a sheet, the first column has
dates (01/01/04) format.
I would like to be able to check something like: 01/01/04 to 05/01/04.
Thanks in advance
Paul

 

[Norman Harker]

Hi Paul!

Try:
=IF(AND(A1>=--"2004-01-01",A1<--"2004-05-01"),TRUE)
OR:
=IF(AND(A1>=DATE(2004,1,1),A1<DATE(2004,5,1)),TRUE)
OR:
=IF(AND(A1>=E1,A1<E2),TRUE)

The third form is usually best as hard coding makes formulas less
adaptable.

The second form might be better if the DATE arguments are constructed
by formulas.

First form is an efficient form of hard coding dates in a format that
is accepted by all international versions of Excel.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)

It is imperative that the patches provided by Microsoft in its April
Security Release be applied to Systems as soon as possible. It is
believed that the likelihood of a worm being released SOON that
exploits one of the vulnerabilities addressed by these patches is VERY
HIGH.
See:
http://www.microsoft.com/security/protect/

 

[Frank Kabel]

Hi
not quite sure what you're trying but you could use the
following formula
=IF(AND(A1>=DATE(2004,4,1),A1<=DATE(2004,4,5)),"within
range", "out of range")

Regards
Frank

 

[Paul Watkins]

Thanks
All work great

Paul

Hi
not quite sure what you're trying but you could use the
following formula
=IF(AND(A1>=DATE(2004,4,1),A1<=DATE(2004,4,5)),"within
range", "out of range")

Regards
Frank