bobgrand
Board Regular
- Joined
- Apr 14, 2008
- Messages
- 244
- Office Version
- 365
- Platform
- Windows
Hello all,
We receive date data in a weird format YYWK. WK represents the Week of the year. Is there a formula that will return a date for the work week of the year.
Example: 1824 - 18 = 2018 - 24 = Work Week 24 of the year would be Monday 06/18/2018.
Any help would be greatly appreciated.
Bob
We receive date data in a weird format YYWK. WK represents the Week of the year. Is there a formula that will return a date for the work week of the year.
Example: 1824 - 18 = 2018 - 24 = Work Week 24 of the year would be Monday 06/18/2018.
Any help would be greatly appreciated.
Bob