formula to determine whether a date falls between two dates
sorry that I posted this question 3x; I kept getting a failure to post message.
"lolan7" wrote:
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.
|