A formula which updates every day?

[Sam_PUG]

Dont even know if its possible but basically i want to have a formula which updates every day. So basicaly I want a formula which only adds a certain cell to the total once it gets to a specified day. I am quite new to excel so sorry if this is easy

[hemesh]

Hello Sam, welcome to the forum, you can use today function combined with other formulas so that can update everyday.

can you upload a work book for better clarity

If answer satisfies you please click" * " at the bottom left corner!

[Sam_PUG]

There is no data in it so it wont make sense. Basically its for finances. I want my bank balance to update weekly. I have a cell for each week with in/outs. Basically, i want the formula to only add in the in/out cell of each week when the week has ended

[hemesh]

Sam you can upload a workbook with data typed manually( what results you are expecting in which cell). if you have a cell for each week then you can use =sum(week1, Week2, week3 and so on..)
here week 1 - week 3 are the cells

If answer satisfies you please click" * " at the bottom left corner!