Ongoing Monthly fees ?

[Supermandan]

Hi,

I am new here and hope everyone is doing well. Ok, here is my question: I need a column that continuously adds up a monthly fee? For instance, I have to pay £10 per month for a storage service, and rather than manually keep adjusting each month I was hoping there was a formula that keeps track of the dates so that, for instance, if the fees began on, say, 10th March, then looking at the spreadsheet in October the formula would automatically know that 8 months had passed (including the original month) and so the cell would show the number "80". How to do this?

Thank you,

DC

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

[Supermandan]

Hi Ali, that's fine and thank you for getting back to me. Though is it necessary to attach the worksheet? it's not the sort of thing I want to do. Can the question be answered? D.

[AliGW]

Not really in this case - we need to see the layout. Please understand that we ask for something if we need it, not if it's unnecessary.

[Supermandan]

Hi Ali, I think I've now attached the spreadsheet. Please confirm and take a look. Very much appreciated, DC

[Supermandan]

Hi Ali, have you had a chance to take a look? Thanks.

[AliGW]

There is nothing attached, so nothing to look at, so no, I haven't!

[Supermandan]

Manage attachments > choose file > upload ? This is the process ? It should be available to see.

[AliGW]

From the big, yellow banner at the top of the page, to which I referred you back in post #2:

Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

[Supermandan]

Is this correct? Is my worksheet attached?

[AliGW]

Yes, and you can see it is. I will have a look later (at work at the moment).

PS I do not see where you have manually mocked up what you want. Again, from the big, yellow banner:

... and some manually calculated results.

[Supermandan]

Hi Ali, appreciate you're busy, just wondering if you'd taken a look yet? Thank you, D.

[Supermandan]

Hi, thank you for taking a look. Ok, I think my terminology is a bit off here. What I mean when saying "manually calculated" is the Storage Fees column. The subtotal is currently added up with the Autosum function, and yet this is the very question that overall I am looking for a solution to: the two current £40 entries are manual in the sense that I manually input 40 to represent 4x £10 per month storage fees when somehow I'm looking for a formula that will take care of the time aspect and just add a 10 to each field's total as the months ticks by; then the Autosum at the bottom remains as it is. Hope this is clear, thank you.

[AliGW]

There have been 235 views of this thread and no offers of help, and that's because your request is still not really clear.

Why do only two items incur storage costs? How should Excel know which items do and which don't?

How and why does an item with the date of 28/08/2020 incur 4 months' storage costs? We are only in the third month ...

There are too many questions for me to provide a solution yet - sorry.

Here's a quick stab in the dark for E3 and copied down:

=(DATEDIF(A3,TODAY(),"m")+1)*10

or this:

=IF(F3="","",(DATEDIF(A3,TODAY(),"m")+1)*10)

[rio.south]

i tried a simple approach: check this is the solution you are looking for.

=IF(A3="", "", ((YEAR(TODAY())-YEAR(A3))*12+MONTH(TODAY())-MONTH(A3)+1)*10)

[Supermandan]

Hi Ali, thank you for this. I've popped the formula into the spreadsheet; all good for now, hopefully this will update as time moves on. Again, thank you, DC

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[Supermandan]

Hi Ali, I've just clicked the star reputation button. I've just tested the formula with some dummy dates, and it clocked correctly; I just want a natural month to pass to see for sure.