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.
 

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
Help to create biweekly dates excluding nonworking days 2
formual to determine if date falls on weekend, adjust date to Mond 4
Need formula to calculate bi-monthly pay dates 5

Back
Top