How to show week numbers for a range of dates

Copper Contributor

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

2 Replies

@Molly-DJS 

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