| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to pull current dates from list w/many dates
If once again you have the date you are intersted in A1 and the data in d5:x5 something like the following will work it can then be copied down ans sorted as before =IF(SUMPRODUCT((D5:X5=$A$1-7)*(D5:X5<=$A$1+7))0,1,0) You may need to change the <= and = to < and depending on what you require Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=513718 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel trying to sort list by a range of dates | Excel Discussion (Misc queries) | |||
| how do i print a list of names and dates in excel into a two-colu. | Excel Discussion (Misc queries) | |||
| FILTER OUT DATES IN LIST | Excel Worksheet Functions | |||
| have dates entered from a list of data into an excel template | Excel Discussion (Misc queries) | |||
| I have a list of dates that I need to count based on a date range | Excel Worksheet Functions | |||
Hybrid Mode
