Full Version: Count a Change to a Cell
UtterAccess Discussion Forums > Microsoft® Office > Microsoft Excel
RAZMaddaz
Is there any function/formula that can count how many times a particular cell, which has a date in it, changes? Thanks!!!

RAZ
NateO
You'd want a VBA Worksheet Change event, if the date is not there by Worksheet Function. See the following:

http://www.cpearson.com/excel/Events.aspx

However, if it's there by function, e.g., Today(), which is volatile, you might want to consider the Calculate event.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.