FlyerTalk Forums - View Single Post - Points expiry not extended after Amex transfer

Sep 12, 2016 | 7:01 pm

#7

:D!

Join Date: Sep 2012

Location: NW London and NW Sydney

Programs: BA Diamond, Hilton Bronze, A3 Diamond, IHG *G

Posts: 7,128

Quote:

Originally Posted by Cymro

Nest it inside an IFERROR function and add the three years to (MAX(A:A)-1).

Why not just add 1093 (to be safe) to the MAX(A:A) and format the cell as a date?

Reply