Ad an amount weekly

[BrownBarry]

Hi I am trying to add a rent amount to a total on a weekly basis.
I have a dashboard that is used by the boss and he wants to have it updated weekly.
Is there a formula that can automatically reference an amount cell and add that amount to the total on a weekly basis. Say every Monday.
Thank you for your help

 

[easy2understandexcel]

You could have a table of data with a schedule of when rent is due, with the amount in the next column.... And just sum everything that is <= today()...

Example, Dates in column A, Rent $$$ in column B

=SUMIF($A$1:$A$99,"<="&TODAY(),$B$1:$B$99)

 

[BrownBarry]

You could have a table of data with a schedule of when rent is due, with the amount in the next column.... And just sum everything that is <= today()...

Example, Dates in column A, Rent $$$ in column B

=SUMIF($A$1:$A$99,"<="&TODAY(),$B$1:$B$99)

Thanks for that I will give it a go when I get home, but looks good.

 

[BrownBarry]

Thank you for that it worked perfectly

 

[easy2understandexcel]

You're welcome!