View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JeanetteS[_2_] JeanetteS[_2_] is offline
external usenet poster
 
Posts: 1
Default finding if a date falls between two dates

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.