adding on a fiscal basis.

  • Thread starter Thread starter Todd
  • Start date Start date
T

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()
 
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?
 
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
 
Back
Top