Forum Discussion

Molly-DJS's avatar
Molly-DJS
Copper Contributor
Mar 06, 2023

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 - 23/4/22
Wk 16 - 23/4/22

Wk 17 - 27/4/22

Wk 17 - 1/5/22

Wk 19 - 8/5/22

excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Mar 06, 2023

    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.

    • Molly-DJS's avatar
      Molly-DJS
      Copper Contributor
      Mar 06, 2023

      HansVogelaar Thank you so much for your speedy response. 

      It worked! Amazing  - I can't thank you enough

Resources