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,T1<K1),"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