Forum Discussion

Copper Contributor

Oct 04, 2022

Solved

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 d...

excel

Formulas and Functions

Lorenzo
Oct 04, 2022
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, "")

Lorenzo

Silver Contributor

Oct 04, 2022

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, "")

Jessica15

Copper Contributor

Oct 04, 2022

Thank you so much! This is perfect! 🙂

Lorenzo
Silver Contributor
Oct 04, 2022
You're welcome. If this solves the issue, there's a link to mark the solution (at the bottom of the reply) - this helps those who search this site... Thanks