Forum Discussion
Anonymous
4 years agoNot applicable
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
- keshavagrawal27
Resolver I
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 🙂