Forum Discussion

RonaldvdH's avatar
RonaldvdH
Post Patron
6 years ago
Solved

Convert date into YEAR-Week

I need to change this formula so that the format will be YYYY-WW THis formula works but the result is 201801 or 201802 so without the '-' between Year and Week   How do i change this formula ?   ...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi RonaldvdH 

    Create a caluclated column

    Column = IF(WEEKNUM([Date])<10,FORMAT([Date],"YYYY-0WW"),FORMAT([Date],"YYYY-WW"))
    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MarlenePirker's avatar
MarlenePirker
Helper I
3 years ago

Hello! So i tried to use the proposed formula but for 1st of Jan 2023 it shows me 2023.52 

Can somebody help me with this? 

 

Thank you! 

 

Best regards, 

Marlene