Hello to all -
I have a Table with dates. In Cell G3 I have the date 2/21/2014.
I need a formula in cell B3 to get Year and Week Number as follows: 2014/02
I have been searching but all that I have found results in 2014/2
Weeks 1 to 9 are shown as 1, 2, 3...
I need Week numbers to be shown like 01, 02, 03...
Can you please help me with a formula to get the result that I need??
I will appreciate the big support.