Newsroom Update

New features come to Apple services this fall. Learn more >

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

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
Question marked as Best reply

Posted on Mar 26, 2020 10:34 AM

Try this:



28×DATEDIF(A2,B2,"D")

Regards,

Barry


2 replies

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 ID.