Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
forecast a financial value at year end | Excel Worksheet Functions | |||
Dates in a Financial Year | Excel Worksheet Functions | |||
Financial Year Weeknum | Excel Discussion (Misc queries) | |||
year quarters === Financial Year | Excel Discussion (Misc queries) | |||
How to compare a date with financial year | Excel Discussion (Misc queries) |