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...
Need Help
Show and Tell
Tips and Tricks
  • keshavagrawal27's avatar
    keshavagrawal27
    4 years ago

    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 🙂
keshavagrawal27's avatar
keshavagrawal27
Resolver I
4 years ago

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 🙂