5 Replies Latest reply on Feb 14, 2019 6:10 PM by Zhouyi Zhang

    How to calculate weeks from todays date to last 365 days.

    sumit shukla

      Hi Experts,

       

      I have a scenario on which i wanted to show number of records week over week from todays to last 52 weeks on a line graph.

      e.g week1 = today()-7, week2= today()-14 and so on for last 52-53 week.

      Can someone help me on this ?

      I am attaching one of my workbook on which i have tried something.

      I need all the 52 weeks in a graph if for few of the weeks number of records are 0 then those weeks also be present on the graph.

      but currently after week 7  i am directly getting week no 46 which is not as per the requirement.