I Need an "Occurs between" date function

  • Thread starter Thread starter alan thompson
  • Start date Start date
A

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
 
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")
 
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
 
Back
Top