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