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
Hi,
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.