Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sun, 19 May 2024 05:43:47 +0000

How to Post a Message for Support

Post From: simple counting spreadsheet cell

[2015-05-25 18:41:32]
[Go To First Post]
Sawtooth - Posts: 4000
This counts from 1 to 20 at each new row, then starts at 1 again, in cell P3:

=IF(OR(MROUND(A3-INT(A3),1/86400)=0,P4=20),1,P4+1)

It starts at midnight, but you could start it at any time, or at any one-time event.