| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check dates against a date range.
Hello,
I am hoping some Excel guru in here can help me out. I have a series of dates in a column mm/dd/yyyy. I want to check these against a named range on another sheet which lists holidays, called holidays. Now if a date in the original column occurs one day before the one of the dates listed on the named range, then the result should read "-1". If two days prior, it should read "-2" and so on. I have tried a vlookup, iferror combination and it's not working. Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check if date is between two dates, then sum only those rows | Excel Worksheet Functions | |||
| check whether a date falls in a range | Excel Discussion (Misc queries) | |||
| Can I check if a date falls between a range then sum other # if tr | Excel Worksheet Functions | |||
| How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
| Check column of dates against todays date | Excel Worksheet Functions | |||
Linear Mode
