AND, MAX
I am working with the formula below. G2 and I2 are dates, or blank. If both
are blank, I would like a blank in the field, if one or both have dates, I
would like the latest date.
=IF(AND(G2,I2)="","",MAX(G2,I2))
Please advise why I get the #Value! error.
Thanks.
|