3 |
=IF($C4="N/A","N/A",INDEX('Fly Days'!$A$2:$A$1000,MATCH($C4,INDEX('Fly Days'!$F$2:$F$1000+ROW('Fly Days'!$F$2:$F$1000)/10000,0),0))) |
=IF($C4="N/A","N/A",INDEX('Fly Days'!$C$2:$C$1000,MATCH($C4,INDEX('Fly Days'!$F$2:$F$1000+ROW('Fly Days'!$F$2:$F$1000)/10000,0),0))) |
=IFERROR(LARGE(INDEX(('Fly Days'!$F$2:$F$1000+ROW('Fly Days'!$F$2:$F$1000)/10000)*('Fly Days'!$F$2:$F$1000>=DATE(YEAR($A$1),MONTH($A$1),1))*('Fly Days'!$F$2:$F$1000<=EOMONTH(DATE(YEAR($A$1),MONTH($A$1),1),0)),0),SUMPRODUCT(('Fly Days'!$F$2:$F$1000>=DATE(YEAR($A$1),MONTH($A$1),1))*('Fly Days'!$F$2:$F$1000<=EOMONTH(DATE(YEAR($A$1),MONTH($A$1),1),0)))-ROW(A1)+1),"N/A") |
Bookmarks