I Need an "Occurs between" date function

[alan thompson]

Hi

I need a function to return true or false as to whether a chosen dat
occurs between two other dates.

EG Column 1 contains START DATES
Column 2 contains an END DATES

Cell A5 is where the user can type the TARGET date

The function I'm looking for would return TRUE if the TARGET date fall
between the START DATE and the END DATE.

If there isn't a built in function to do this then do i need to post i
the programming forum ?

Many thanks

Ala

 

[Frank Kabel]

Hi
if A1 has the start date, B1 the end date and C1 your tagret date try
=IF(AND(C1>=A1,C1<=B1),"Target is within range","Target is out of
range")

 

[BrianB]

I do not think that we can understand what you are trying to do.

You mention a list of START and END "DATES" (in the plural)
and then trying to find if a date is between *the* START DATE and *the
END DATE