finding if a date falls between two dates

  • Thread starter Thread starter JeanetteS
  • Start date Start date
J

JeanetteS

Hi. I hope there's an answer to this problem:
N column is "Start Date",
O column is "End Date",
I have a named range "holidays" in U3:U9.
I need to find out if any of the "holidays" date fall within my Start Dates
and my End Dates, which vary from row to row.
 
The result will be in another cell.
Ultimately I will need to know which of the holidays falls within the
Start/End dates on any given line because I will need to know what day of the
week (mon, tue, etc., --which are listed in V3:V9 next to the holidays using
a TEXT formula) and then use this information to subtract those days from a
total number of sessions/hours which have been calculated in different
columns.

The sessions don't happen every day; some are on Mondays, some on Tuesdays &
Thursdays, etc.
 
Back
Top