| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
finding if a date falls between two dates
sorry that I posted this question 3x; I kept getting a failure to post message.
"JeanetteS" 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 "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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
finding if a date falls between two dates
On Feb 10, 1:15*pm, JeanetteS
wrote: 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. SUMPRODUCT((N2<=U3:U9)*(U3:U9<=O2)) returns the number of holidays between the dates in N2 and O2. The following tells you if at least one holiday is between those dates: =if(sumproduct((N2<=U3:U9)*(U3:U9<=O2))=0,"none"," at least one") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Test if a date falls within a given range of dates in Excel? | Excel Worksheet Functions | |||
| Finding quantity that falls within a range or Tier | Excel Worksheet Functions | |||
| return TRUE if a date falls between two dates | Excel Worksheet Functions | |||
| Finding whether a date falls between a certain category | Excel Worksheet Functions | |||
| How to find if a date falls between 2 dates | Excel Worksheet Functions | |||
Linear Mode
