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.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
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
Try this:
28×DATEDIF(A2,B2,"D")
Regards,
Barry
Try this:
28×DATEDIF(A2,B2,"D")
Regards,
Barry
Barry,
That worked perfectly. I used the TODAY function for the current date so when it updates every day the value cell now updates. Thanks so much!
Increase numbers cell value daily
