Adding a value to another value every Friday

Copper Contributor

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?

3 Replies
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)
You’re welcome!