Mar 06 2023 02:55 PM
I'm importing a years worth of invoices from xero. I want to be able to quickly see what week number that invoice date falls into.
So:
23/4/22
23/4/22
27/4/22
1/5/22
8/5/22
Becomes
Wk 16 - 23/4/22
Wk 16 - 23/4/22
Wk 17 - 27/4/22
Wk 17 - 1/5/22
Wk 19 - 8/5/22
Mar 06 2023 03:06 PM
I'd use a separate column for the week numbers.
Let's say the dates are in A2 and down.
In B2:
=ISOWEEKNUM(A2)
If you prefer, you can set the number format of B2 to the custom format
"Wk "0
Fill or copy down from B2.
Mar 06 2023 03:41 PM
@HansVogelaar Thank you so much for your speedy response.
It worked! Amazing - I can't thank you enough