Forum Discussion

Jessica15's avatar
Jessica15
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 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, "")

     

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor

    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's avatar
      Jessica15
      Copper Contributor
      Thank you so much! This is perfect! 🙂
      • Lorenzo's avatar
        Lorenzo
        Silver Contributor
        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

Resources