Increase numbers cell value daily

I'm trying to figure out how to set a cell value to increase daily. For example, using calendar year 2020, I would like to set the value to 28 for 1 Jan, then have it automatically increase by 28 each day for the remainder of the year. So if I open the document on 10 Jan, the cell value would auto update to 280 (28 x 10 days).

MacBook Pro 13", macOS 10.15

Posted on Mar 26, 2020 8:50 AM

Reply
2 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Increase numbers cell value daily

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