Forum Discussion

saleh1335's avatar
saleh1335
Copper Contributor
Mar 28, 2020

Adding a value to another value every Friday

I want to be able to do the following:
Add $25 to a principal amount of $3500 every single Friday
What combination of formulas would I have to use in order to be able to do this?

Formulas and Functions

3 Replies

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Mar 28, 2020
    If the dates start in A2 and the amounts start in B2, which has the value of 3,500, enter this formula in B3, and copy down rows as needed:
    =B2+25*(WEEKDAY(A3)=6)