You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

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

fellwalker Author

Level 1

4 points

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

Top-ranking reply

Barry

Level 9

59,951 points

Posted on Aug 5, 2020 12:34 AM

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

">="&TODAY()

Regards,

Barry

View in context

Auto advance of date from table

Similar questions