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?
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)