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

JBeaucaire

Once the comparison is made, what do you want to happen? Is the resul
of this comparison going to be in another cell? How are you respondin
to this information in the sheet
 
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
Check dates against a date range. 0
Count specific days in between dates 2
Date range within a date range 2
Check if a date comes before/after a range of dates 0
IF - Date falls between two dates, place here 3
Show value from one cell in another cell if today falls between a date range 5

Top