|
|
|
|
#1
01-22-2019, 01:33 AM
|
|||
|
|||
Attached is an example, with 2 formulas - one uses ISO week definition, another US week definition (and according WEEKDAY() function parameters). The result is same of-course.
The start date is Monday of week, where Start Date defined on Sheet SetUp belongs to. 
|
|
| Tags |
| date calculations |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Changing euro signs to other currencies in big excel format including graphs | OfficeOffice | Excel | 1 | 06-15-2017 06:53 AM |
| Want to export Excel workbook to PDF for use on both PCs and tablets including iOS | janesmith230 | Excel | 0 | 01-08-2017 05:56 PM |
| Saturday off alternately | marif300 | Project | 21 | 09-24-2014 05:45 AM |
| Word 2013 macro to generate last day of each week (Saturday) | CrabApple | Word | 1 | 11-08-2013 02:40 PM |
| Macro to DT Picker, but default to Weekdays | ofair | Word VBA | 1 | 05-21-2013 03:07 PM |
Windows 8 
Office 2016
Hybrid Mode