2 Replies Latest reply on Jul 2, 2018 5:05 AM by Hamza Alsalman

    WTD, MTD,YTD

    Hamza Alsalman

      Hello,

      I have to calculate the balance amounts as of today, month to date, year to date. Essentially what i need to do is calculate the sum of a balance column in excel for the day and subtract that minus the beginning of the month's value for month to date. For year to date I must calculate 01/01 of every year and take the difference of today's balance-01/01's date. For the week to date what i need to do is calculate the beginning of the week so every monday and subtract the today date from every monday of each week. How do I do these formulas as all recurrring without the need to keep updating.

       

      Thank you in advance!