Between two dates

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

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(T1J1,T1K1),"within","outside")&" range"

Hope this helps.

Pete

On Dec 10, 2:47*pm, jen-chi wrote:
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

This will return TRUE or FALSE
=(AND(T1J1,T1K1)

This will return whatever text you want
=IF(AND(T1J1,T1K1),"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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"jen-chi" wrote in message
...
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

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!
================================================== ===


"jen-chi" wrote in message
...
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