6 Replies Latest reply: Feb 21, 2018 7:28 AM by Thiago Justen Teixeira RSS

    Finding WeekNo -Feb as Year Starting and Sunday as weekstart

    Surya Shanmugam

      Hi

       

      I have to find week no from given Invoice date.

       

      Feb is the year start

      Sunday is the week start

       

      Div((Invoice_Date-YearStart(Invoice_Date,0,2)-WeekDay(YearStart(Invoice_Date))+3),7)+1

       

       

      Any help is appreciated. Thanks

      Date.JPG