Hi Folks,
I am a newbie of this forum (my first post). I was reading around and could not find my answer. So here is my problem:
I have second row (B) on my spreadsheet showing date (12 months rolling) and on the cells beside (D "Innocent") which currently are populated with number of occurrences (usually number "1" or just empty) I would like the number "1" to be erased or zeroed if date column value is older than 12 months rolling (=TODAY()-365). Please see the example attachment. I would appreciate your help. My excel version is 2010.
Bookmarks