ExcelBanter - if date between

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - if date between (https://www.excelbanter.com/excel-discussion-misc-queries/258129-if-date-between.html)

Deb

if date between

Date1 Date2 date3
1/1/2010 3/31/2010 2/5/2010

if date3 is between data 1 and date2 then true else false

How can I enter this?
--
deb

Luke M[_4_]

if date between

=AND(C2A2,A2<B2)

--
Best Regards,

Luke M
"deb" wrote in message
...
Date1 Date2 date3
1/1/2010 3/31/2010 2/5/2010

if date3 is between data 1 and date2 then true else false

How can I enter this?
--
deb

Gary''s Student

if date between

=AND((C1=A1),(C1<=B1))

--
Gary''s Student - gsnu201001

"deb" wrote:

Date1 Date2 date3
1/1/2010 3/31/2010 2/5/2010

if date3 is between data 1 and date2 then true else false

How can I enter this?
--
deb

David Biddulph[_2_]

if date between

=MEDIAN(A2,B2,C2)=C2
--
David Biddulph

"deb" wrote in message
...
Date1 Date2 date3
1/1/2010 3/31/2010 2/5/2010

if date3 is between data 1 and date2 then true else false

How can I enter this?
--
deb

All times are GMT +1. The time now is 03:10 AM.