Daily updating within a formula

[hugoaparedes]

Hello,
my excel knowledge is very basic. I can't figure out, if its even possible, how to set a spreadsheet to automatically update according to the day of the month.
Any help would be greatly appreciated.
Thanks

[jeffreybrown]

Hello & Welcome to the Forum,

This will give you today's date and will change as the date changes.

=DAY(TODAY())

[hugoaparedes]

Thank you. my problem is that i have set goals . within these goals there is a pace that i want calculated upto date. i have the formula entered i just want it to update itself every day
thanks for the help.

[jeffreybrown]

i have the formula entered i just want it to update itself every day

Not so sure this completely makes sense to me. How about attaching a sample spreadsheet with a before and after?

[hugoaparedes]

i want the information on column E to change automatically each day. Additionally, if the information on column D changes then it will be reflected in column E

[jeffreybrown]

I'm guessing the 23 stands for today the 23rd? >> =D6/23*31

If so, in T1 put the formula >> =TODAY()

Then in E6 and copied down >> =D6/DAY($T$1)*31

[hugoaparedes]

thank you very much for your help. however i am following your instructions and im curious why in cell T1.
Also it doesnt seem to be working for me im not sure if im doing it correctly since i keep getting #####.
thanks for your help

[jeffreybrown]

I'm using T1 so you don't have many many cells filled with a volatie function.

As far as the #####, the cells is not wide enough, although that is becasuse it is trying to calculate it as a date.

You actually want it to be a number so format as so...

If you don't want to use a helper cell >> =D6/DAY(TODAY())*31

[hugoaparedes]

Jeff you are the MAN!! thanks

[jeffreybrown]

Glad it worked out for you and you are very welcome.