Forum Discussion

Copper Contributor

Oct 17, 2018

Solved

Excel Formula Help - One Monthly Amount Auto Calculated From Start Date

Wondering if someone can help me, I am completely stuck. I need a formula in Column D that will give me a monthly running total of Column C that will auto update with the current date by month, but t...

excel

Formulas and Functions

Detlef_Lewin
Oct 17, 2018
Hello Linday

Try this:
=(DATEDIF(A2,TODAY(),"m")+1)*C2

Detlef_Lewin

Silver Contributor

Oct 17, 2018

Hello Linday

Try this:

=(DATEDIF(A2,TODAY(),"m")+1)*C2

Lindsay Miller

Copper Contributor

Oct 17, 2018

That worked!You're awesome! Thank you so much! :)