David, thank you for your response..

1. how would i look up calendar year for each type of fuel (unleaded = U,
diesel = D)?

2. Fiscal year is 07/01/09 to 06/31/10. The same would apply for each type
of fuel as above (unleaded = U, diesel = D).

Thank you, Penny

"David Biddulph" wrote:

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

.