• how to automatically increase a value on a specific date each month on

    From Dalton Biggs@21:1/5 to All on Tue Mar 14 13:46:13 2023

    I am trying to find a formula on google sheet that will automatically increase a value in a cell. I need to start with today's figure and periodically add April-August's figures on those specific dates into Cell D3.

    Today 3/14/2023 657.83
    April 4/5/2023 394.7
    May 5/5/2023 394.7
    June 6/5/2023 394.7
    July 7/5/2023 394.7
    August 8/5/2023 384.65

    If anybody can help that would be greatly appreciated.



    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)