Every day I open my spreadsheet and add values to cells....similar to a teacher adding test scores of a student. I plan on creating a weekly calendar inside of Excel on my current spreadsheet...something simple that says Monday, Tuesday, Wednesday, Thursday, Friday...that's it. I'd like Excel to note as I add a test score, to increase the number of evaluations I did to the associated day I added the test score.

How's that for stream of consciousness? heheh...lemme try again...

When I open the spreadsheet....on a Monday for example, I'd like Excel to note if a value increases in any of 7 particular cells, to add '1' to the Monday cell. The next day when I come in, if I do an evaluation, I'd like it to note that I added an evaluation on Tuesday and mark it in the appropriate box.

Basically, I'm trying to count how many evaluations I do per day...so when I open it on a Tuesday, it will add the number to the Tueday cell Can this be done somehow? I assumed that Excel would use the NOW function and use the date from the system clock or something to determine where to place the value.

Thank you so much in advance for your help.