Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Auto advance of date from table

Hi, can anyone help me?

I am trying to create a countdown reference to my retirement. I want the spreadsheet to automatically update each time I load it. As below



I am referencing this table below to display the info above.


My problem is how do I replace the date reference in the above formula ">=04/08/20" with an auto date from the system or "now" function. so the display is automatically up to date. Obviously 04/08/20 is ok for today but tomorrow it needs to be 05/08/20. ( sorry American readers I am from UK so this represents 4th August 2020).

Any help appriciated.

iMac Pro

Posted on Aug 4, 2020 11:45 AM

Reply
Question marked as Best reply

Posted on Aug 5, 2020 12:34 AM

Replace ">=04/08/20" in the formula with

              ">="&TODAY()


Regards,

Barry

Similar questions

2 replies

Auto advance of date from table

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.