Numbers – Days since last flight

No Comments

Unfortunately Numbers doesn’t recognise the formulas used to calculate the Days since Last Flight.

However you can use this formula (specific to Numbers for Mac/iOS) which will return the same result.

Simply copy and paste this formula into the top aircraft type row and copy/fill down to the other rows.

=TODAY()−IF(COUNTIF(Logbook::Table 1::B,C6)>0,INDEX(Logbook::Table 1::A,MATCH(C6,Logbook::Table 1::B,1)),"N/A")

No Comments

    Leave a Comment

    Other posts you might find helpful

    See all posts