5 Replies Latest reply: Mar 21, 2018 3:41 PM by Jahanzeb Hashmi RSS

    Formula to calculate the week start date with Monday as beginning of week.

    Deborah Levin

      I have an [Audit Date] field. I would like to create a simple formula that will determine the week starting date (with Monday as the week starting date). for example, if the [Audit Date] = 03/21/2018, I would like the Week Start Date to show  03/19/2018.  If the Audit date was 02/09/2018, the week start date should be 02/05/208.

       

      What is the best formula to use?