Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calendar - Week number has incorrect start date

Hello Team,

 

Hope you are fine.

 

I am trying to add a week number in my calendar using the below:

 

Calendar = ADDCOLUMNS(CALENDAR(Date(2021,10,01), date(2030,12,31))
,"Month Year", Format([Date], "MMM-YYYY")
,"Month Year sort", Format([Date], "YYYYMM")
,"Year", Year([Date])
,"YYYY-WK", FORMAT([Date],"YYYY-WW")
,"Qtr Year", Format([Date],"YYYY\QQ"))
 
However, the start date for the week is incorrect as it starts on a Sunday:
 
 
Do you have an idea on how to resolve it?
 
Thank you.
 
Kind Regards,
 
  • Hi Anonymous ,

    Try below:

    Calendar = ADDCOLUMNS(CALENDAR(Date(2021,10,01), date(2030,12,31))
    ,"Month Year"Format([Date]"MMM-YYYY")
    ,"Month Year sort"Format([Date]"YYYYMM")
    ,"Year"Year([Date])
    ,"YYYY-WK", Concat(FORMAT([Date],"YYYY"),WeekDay([Date],2))
    ,"Qtr Year"Format([Date],"YYYY\QQ"))
     
    Please mark it as a solution if it satisfies your requirement 🙂

1 Reply

  • Hi Anonymous ,

    Try below:

    Calendar = ADDCOLUMNS(CALENDAR(Date(2021,10,01), date(2030,12,31))
    ,"Month Year"Format([Date]"MMM-YYYY")
    ,"Month Year sort"Format([Date]"YYYYMM")
    ,"Year"Year([Date])
    ,"YYYY-WK", Concat(FORMAT([Date],"YYYY"),WeekDay([Date],2))
    ,"Qtr Year"Format([Date],"YYYY\QQ"))
     
    Please mark it as a solution if it satisfies your requirement 🙂