Whcih financial year?
 

Hi All,

I am working on a project with the financial year being 1
April to 31 March. I need to calculate a percentage of
costs depending on what month of this FY they are
incurred. If costs are incurred in , say, May of the
CURRENT year then charge 10%/12*11, June would be
10%/12*10 etc. However, the month will become irrelevant
in the next FY when the charge for these existing costs
would be 10% and for all new additions of costs in that
new FY would be charged with appropriate proportions like
above.

I have tried with Month and Year functions. But not
getting very accurate as the financial year is different
than normal year. I need to write a formula to place in
the correct column everytime the report is run.Have you
done something like this before? Ideas? Any help would be
much appreciated. Thanks in advance.

Whcih financial year?
 

Sorry, I should have mentioned that at the end of each
year i would need to calculate the net cost remaing after
the charges to that point. Hope this makes sense. Thanks.

-----Original Message-----
Hi All,

I am working on a project with the financial year being 1
April to 31 March. I need to calculate a percentage of
costs depending on what month of this FY they are
incurred. If costs are incurred in , say, May of the
CURRENT year then charge 10%/12*11, June would be
10%/12*10 etc. However, the month will become irrelevant
in the next FY when the charge for these existing costs
would be 10% and for all new additions of costs in that
new FY would be charged with appropriate proportions like
above.

I have tried with Month and Year functions. But not
getting very accurate as the financial year is different
than normal year. I need to write a formula to place in
the correct column everytime the report is run.Have you
done something like this before? Ideas? Any help would be
much appreciated. Thanks in advance.
.

Whcih financial year?
 

Hi Jamie
It seems you need to start the year as April = Month 12, with Mar = Month 1

If you take the current month and if it is 3 or less add 8, else substract 4
take, the result from 12 and you are left with the number of months left in
the FY.

Try this which uses the system date to get the current month......

=12-IF(MONTH(NOW())<4,MONTH(NOW())+8,MONTH(NOW()))

Cheers
Nigel

"Jamie" wrote in message
...
Hi All,

I am working on a project with the financial year being 1
April to 31 March. I need to calculate a percentage of
costs depending on what month of this FY they are
incurred. If costs are incurred in , say, May of the
CURRENT year then charge 10%/12*11, June would be
10%/12*10 etc. However, the month will become irrelevant
in the next FY when the charge for these existing costs
would be 10% and for all new additions of costs in that
new FY would be charged with appropriate proportions like
above.

I have tried with Month and Year functions. But not
getting very accurate as the financial year is different
than normal year. I need to write a formula to place in
the correct column everytime the report is run.Have you
done something like this before? Ideas? Any help would be
much appreciated. Thanks in advance.




----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---