finding if a date falls between two dates

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.
 
L

lolan7

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

finding if a date falls between two dates 2
formula to determine whether a date falls between two dates 7
Excel Help with dates 2
Date range within a date range 2
Count specific days in between dates 2
IF - Date falls between two dates, place here 3
Macro to delete rows based between two specific dates 0
Between two dates 3

Top