Forum Discussion
How to show week numbers for a range of dates
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 - 2...
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.
HansVogelaar Thank you so much for your speedy response.
It worked! Amazing - I can't thank you enough