mardi 24 février 2015

Automatically calculate current year in criteria string of CountIFs statement

I want to count certain values using an excel formula. I am using CountIFs but the problem is that my value has the current year as a part of the string. For example one of the values are CMS 2015. I was wondering if there was a way to incorporate a function in the criteria string so that it will automatically calculate the year? Also, I would like to search for the same string only one year ahead of the current (eg. CMS 2016). Any help would be greatly appreciated!


Aucun commentaire:

Enregistrer un commentaire