Between two dates

[jen-chi]

I have three dates on the spreadsheet and I need to know if the third date is
within the parameters of the first two...

Column J = 03/21/07 (start date)
column K = 05/15/07 (end date)
column T = 03/06/07 (date to be checked)

I need a forumla that will tell me if the third date is within the first
two. Please help

 

[Pete_UK]

Try this:

=IF(AND(T1>=J1,T1<=K1),"within","outside")&" range"

This assumes the range includes the start and end dates, but if the
range is exclusive of these dates then you can use:

=IF(AND(T1>J1,T1<K1),"within","outside")&" range"

Hope this helps.

Pete

 

[Bernard Liengme]

This will return TRUE or FALSE
=(AND(T1>J1,T1<K1)

This will return whatever text you want
=IF(AND(T1>J1,T1<K1),"OK,"Bad")

I have taken 'between' literally. So if T-date is exactly the same as
J-date you get false
You may wish to use
=(AND(T1>=J1,T1<=K1)
to include the two critical dates
best wishes

 

[RagDyeR]

This returns True if between dates,
False if not:

=AND(T1>=J1,T1<=K1)

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


I have three dates on the spreadsheet and I need to know if the third date
is
within the parameters of the first two...

Column J = 03/21/07 (start date)
column K = 05/15/07 (end date)
column T = 03/06/07 (date to be checked)

I need a forumla that will tell me if the third date is within the first
two. Please help