I'm looking for a formula that picks fiscal year / calendar year from a sheet
that contains:

a - date
b - type of fuel (U or D)
c - amount (gallons)
d - price per gallon

Any help is truly appreciated!

mePenny

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" <(E-Mail Removed)> wrote in messagenewsC519360-9C45-4DCA-B5A3-(E-Mail Removed)...> 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

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" <(E-Mail Removed)> wrote in messagenewsC519360-9C45-4DCA-B5A3-(E-Mail Removed)...> 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
>
> .
>

If this is confusing, i'm sorry. Let me break the page down so you'll have a
better idea:

HEADINGS ONLY:
A4 - DATE
B4 - TYPE OF FUEL (U = UNLEADED, D = DIESEL)
C4 - GALLON AMOUNT OF FUEL DELIVERED
D4 - PRICE PER GALLON AT TIME OF DELIVERY

ENTRIES ONLY:
A6 - A24 ARE THE ENTRIES OF FUEL DELIVERED

G5 - CALENDAR YEAR (HEADING ONLY)
G6 - (WORD ONLY) UNLEADED H6 - (NEED FORMULA HERE)
G7 - (WORD ONLY) DIESEL H7 - (NEED FORUMLA HERE)

G9 - FISCAL YEAR (HEADING ONLY)
G10 - (WORD ONLY) UNLEADED H10 - (NEED FORMULA HERE)
G11 - (WORD ONLY) DIESEL H11 - (NEED FORMULA HERE)

Okay, what i'm looking for is the formulas for H6,H7,H10,H11
H6,H7: I need to pull the amount of fuel delivered in the current calendar
year for each type of fuel (H6 unleaded, H7 diesel)
H10,H11: I need to pull the amount of fuel delivered in the current fiscal
year (7/1/09 - 6/30/10) for each type of fuel (H10 unleaded, H11 diesel)

I'm hoping this is a better explination.
Penny


"mePenny" wrote:

> 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" <(E-Mail Removed)> wrote in messagenewsC519360-9C45-4DCA-B5A3-(E-Mail Removed)...> 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
> >
> > .
> >

Can anyone help me with this issue?



"mePenny" wrote:

> I'm looking for a formula that picks fiscal year / calendar year from a sheet
> that contains:
>
> a - date
> b - type of fuel (U or D)
> c - amount (gallons)
> d - price per gallon
>
> Any help is truly appreciated!
>
> mePenny