Hello,

I use this formula to define the week number according to the month and it resets again starting the new month.

LPSD is my Licence Period start date

VALUE(DATETIME_FORMAT(LPSD,‘w’))-

VALUE(DATETIME_FORMAT(DATETIME_PARSE(‘01’&DATETIME_FORMAT(LPSD,‘MM’)&YEAR(LPSD),‘DDMMYYYY’),‘w’))+1

it’s giving me a wrong week no: week -47. when it’s week 5

is there a slight modify can solve this?

thanks