FlyerTalk Forums - View Single Post - Points expiry not extended after Amex transfer
Thread: Points expiry not extended after Amex transfer
View Single Post
Old Sep 14, 2016 | 8:36 am
  #8  
Hobbes01
10 Countries Visited
20 Countries Visited
30 Countries Visited
20 Years on Site
 
Join Date: Nov 2005
Programs: BA, AA, FB
Posts: 562
Originally Posted by Cymro
Nest it inside an IFERROR function and add the three years to (MAX(A:A)-1).
Wouldn't using (MAX(A:A)-1) - I am guessing you mean for the day value - add twelve potential errors for when the last transaction took place on the first of a month?

Originally Posted by :D!
Why not just add 1093 (to be safe) to the MAX(A:A) and format the cell as a date?
While it could be considered the conservative route to use a date earlier than the actual expiration date, where would be the fun in that?!

Sorry ranjanrocks didn't mean to go off on a tangent here.
Hobbes01 is offline  
Reply