Adding a value to another value every Friday

%3CLINGO-SUB%20id%3D%22lingo-sub-1261843%22%20slang%3D%22en-US%22%3EAdding%20a%20value%20to%20another%20value%20every%20Friday%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1261843%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20be%20able%20to%20do%20the%20following%3A%3CBR%20%2F%3EAdd%20%2425%20to%20a%20principal%20amount%20of%20%243500%20every%20single%20Friday%3CBR%20%2F%3EWhat%20combination%20of%20formulas%20would%20I%20have%20to%20use%20in%20order%20to%20be%20able%20to%20do%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1261843%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1261987%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20a%20value%20to%20another%20value%20every%20Friday%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1261987%22%20slang%3D%22en-US%22%3EIf%20the%20dates%20start%20in%20A2%20and%20the%20amounts%20start%20in%20B2%2C%20which%20has%20the%20value%20of%203%2C500%2C%20enter%20this%20formula%20in%20B3%2C%20and%20copy%20down%20rows%20as%20needed%3A%3CBR%20%2F%3E%3DB2%2B25*(WEEKDAY(A3)%3D6)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1280256%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20a%20value%20to%20another%20value%20every%20Friday%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1280256%22%20slang%3D%22en-US%22%3EThanks%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1280287%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20a%20value%20to%20another%20value%20every%20Friday%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1280287%22%20slang%3D%22en-US%22%3EYou%E2%80%99re%20welcome!%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted
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)
Highlighted
Highlighted
You’re welcome!