Forum Discussion
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 the challenge is it needs to be a monthly total from the start date of Column A. For example Column D should have $460 for recognizing 2 months so far of the contract (September and October)
Anybody know of a formula that will do this? Thanks in advance for your help!
| COLUMN A | COLUMN B | COLUMN C | COLUMN D |
| Current Contract Year Date | Current Expiration Date | Monthly Revenue Recognized | Revenue Recognized YTD |
| 9/1/2018 | 9/1/2019 | $230.00 |
Hello Linday
Try this:
=(DATEDIF(A2,TODAY(),"m")+1)*C2
2 Replies
Hello Linday
Try this:
=(DATEDIF(A2,TODAY(),"m")+1)*C2
That worked!You're awesome! Thank you so much! :)
