Hi i need to group dates in Excel based on a unnatural selection, namely Saturday to Thursday, so i need an alternative for WEEKNR, could you please help? - i need an unique value like WEEKNR for the dates for each period, for example ("03-11-2018 - 08-11-2018" for the dates within this group)
<tbody>
</tbody>
Date | DATEVALUE | Name for unique value |
01-11-2018 | 4 | |
02-11-2018 | 5 | |
03-11-2018 | 6 | |
04-11-2018 | 7 | |
05-11-2018 | 1 | |
06-11-2018 | 2 | |
07-11-2018 | 3 |
<tbody>
</tbody>