bobgrand
Board Regular
- Joined
- Apr 14, 2008
- Messages
- 244
- Office Version
- 365
- Platform
- Windows
Hello all, I hope we are all being safe these days.
I am trying to create a formula to change the date 2/14/2020 to be a Year & Week of the year format.
Examples
DATE ------- Converted to YYWK
2/14/2020 = 2007
2/21/2020 = 2008
2/28/2020 = 2009
3/6/2020 = 2010
3/13/2020 = 2011
Any help would be greatly appreciated.
I am trying to create a formula to change the date 2/14/2020 to be a Year & Week of the year format.
Examples
DATE ------- Converted to YYWK
2/14/2020 = 2007
2/21/2020 = 2008
2/28/2020 = 2009
3/6/2020 = 2010
3/13/2020 = 2011
Any help would be greatly appreciated.