adding on a fiscal basis.

[Todd]

How do you add a numbers in a cell automaticly on a
fiscal basis not a calender basis.I am using the formula

=(month($g$31))*8
cell g31 has = today()

 

[Myrna Larson]

Can you explain what you mean by "add a numbers in a cell automatically"? Do you have 12 cells
for the monthly amounts? Where are those cells? Where do you specify the month in which your
fiscal year begins?

 

[Tom Ogilvy]

are you trying to have month return 1 - 12 based on Apr or Jul or Oct being
equal to 1?

assume the first month is July.

in B1 to B12 put in the numbers 1 to 12
In c1 enter the formula

=B1-6+(B1<=6)*12

then drag fill down the column.

this will show you how to shift the month numbers.

=(Month($g$31)-6+(Month($g$31)<=6)*12)*8

change 6 to 3 for Apr or 6 to 9 for Oct.

regards,
Tom Ogilvy