orangebloss
Board Regular
- Joined
- Jun 5, 2013
- Messages
- 51
- Office Version
- 365
- Platform
- Windows
Hi all
I'm trying to work out if it's possible to calculate whether or not a given week contains the last Friday and if so place some kind of marker to flag this up so that I can determine which reporting month it should be in. Any help appreciated!
I'm trying to work out if it's possible to calculate whether or not a given week contains the last Friday and if so place some kind of marker to flag this up so that I can determine which reporting month it should be in. Any help appreciated!
W/C | 01/01/2018 | 08/01/2018 | 15/01/2018 | 22/01/2018 | 29/01/2018 |
Week Num | 1 | 2 | 3 | 4 | 5 |
Contains last Friday of month? | No | No | No | Yes | No |
Reporting Month | Jan | Jan | Jan | Jan | Feb |