lundi 22 août 2016

Excel - Calculate date closest to system date

I have 4 fields that holds date information that are updated periodically, I need to add a 5th field that does the following for reporting in a pivot table:

Checks if all the fields are blank, if not calculate the field value (a date) that is closest to the system date(current date), I have the first part but the second part of the if statement has me stumped.

IF(AND(GT14="",GU14="",GV14="",GW14="",GX14=""),"No Tollgate Dates",if statement to field that is closest to most recent month)

Any help would be greatly appreciated.

Aucun commentaire:

Enregistrer un commentaire