| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup date range row A and count if leave in same column on row B
Hi
I am attempting in Excel 2003 to lookup a date range in row A and then count leave booked in row B. e.g. 01 02 03 04 05 TIM L L L KIM L L Count leave for Tim period 02 to 04 inclusive. (L's for leave could be replaced with numeric) Please note that 1. The date range would be entered in two seperate cells not directly into the function. 2. The date period in row A would be running for a year so any function would need to search the entire period. -- Cheers Pappa Smurf |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Unique Values in 1 Column based on Date Range in another Column | Excel Worksheet Functions | |||
| Lookup / return latest date in range AND value of 1 column to the | Excel Worksheet Functions | |||
| 2 column lookup - match to date range | Excel Worksheet Functions | |||
| How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
| Count cells based on date range in another column | New Users to Excel | |||
Threaded Mode
