View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default formula to determine whether a date falls between two dates

Ok, so what kind of result do you want? A count? A "Yes" or "No"?
True/False?

--
Biff
Microsoft Excel MVP


"lolan7" wrote in message
...
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 (not sure whether this is necessary) "holidays" in
U3:U9.

I need to find out if any of the "holidays" dates fall within my Start
Dates
and my End Dates, which vary from row to row.

thanks for being brilliant.