|
|
#7
05-19-2020, 10:55 PM
|
|||
|
|||
Quote:
 Some details are missing for me! Are you meaning week as calendary unit, or as 7-day time period? When week is calendary unit, then do you use US calendary (the week starts with Sunday) or ISO Calendary (the week starts with Monday)? When week is 7-day time period, then does it apply to dates before and after H0004 (13 days total), or only for dates after H0004 (7 days total)? Must all conditions apply for all H0004 codes for same ID, or only for latest one (e.g. what happens when in year 2018 was H0004 with another code in next day, but in year 2019 was H0004 without any other code less than 7 days apart)? How must rows with no dates handled? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Select multiple check boxes at once. | Batchook | Word | 0 | 09-08-2016 03:44 PM |
 Excel vba to check to check if two columns are empty
|
subspace3 | Excel Programming | 5 | 07-09-2015 04:45 PM |
| Multiple Check In/check Out Times | big0 | Excel | 4 | 09-19-2013 05:02 AM |
|
cannot check/uncheck check box but added check box
|
learn2office | Word | 1 | 11-27-2012 02:02 AM |
| Link word check box to access check box | Mrkieth | Word | 4 | 01-30-2012 06:43 AM |
Windows 8 
Office 2016
Threaded Mode