Forum Discussion
Jessica15
Oct 04, 2022Copper Contributor
Populate a figure on the same date each month
Hi All, If I have a whole year worth of dates in a row eg 01/01/2022 02/01/2022 03/01/2022 (Aus date format) is there a way to populate the same figure (in this situation lets say $800) on the same date each month. For example is a row below the date row on the 2nd of each month populate $800.
So; 02/01/2022 $800
02/02/2022 $800
02/03/2022 $800
02/04/2022 $800
02/05/2022 $800 ext ext.... Thank you.
Hi Jessica15
Let's say your dates are in A1:GB1
In A2: =IF(DAY(A1) = 2, 800, ""), then copy right until GB1
If you run Excel 2021 or 365, in A2: =IF(DAY(A1:GB1) = 2, 800, "")