mardi 31 août 2021

IF statement for multiple date ranges

I built a tracker for my platoon to manage numerous training dates based on completion. Each sheet tracks different things and I'm trying to make a coversheet that pulls data from each sheet to give an overall snap shot. I'm trying to create and IF formula for if any of the dates in a certain row are over due, it reports as over do. I can do it with 1 or 2 but not with 14 different dates. Is this possible?

Aucun commentaire:

Enregistrer un commentaire