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.