If you have a date in A1, the formula for the calendar year is =YEAR(A1).

If you tell us your definition of fiscal year, we can tell you the formula.
One possibility might be
=IF(MONTH(A1)3,YEAR(A1)&"-"&RIGHT(YEAR(A1)+1,2),YEAR(A1)-1&"-"&RIGHT(YEAR(A1),2))--David Biddulph"mePenny" wrote in ... I'm looking for a formula that picks fiscal year / calendar year from asheet that contains: a - date b - type of fuel (U or D) c - amount (gallons) d - price per gallon Any help is truly appreciated! mePenny