I have a workbook that has a cell that’s counts the number of times it is opened each day but need to reset the value to zero the first time it is opened after midnight.
In short the count is used to trigger an automatic email reminder but I only want it to send once a day so when the count is 1 it will send the email but when it increases to above 1 no more emails will be sent until the following day.
The count works fine but I have no idea how to the value in C5 back to zero each day.
Can anybody help please? I have uploaded an example workbook.
Thank you
Mykal
Reply With Quote