Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calcuating annualised year to date income
Try this.
=(C1/(DATEDIF(A1,B1,"m")+1))*12 Where A1 = start date of financial year B1 = payslip date C1 is earnings to date When entering this Excel will try to change the format of your cell to date so change it back to general. "Sam" wrote: Hello all I want to create a formula to annualise a persons income based on their gross financial year to date income. Assuming that the financial year begins on 1/7/06. The variables would be:- Financial year start date (1/7/06) Date of payslip Year to date gross income Result to calculate what the annualised income would be come 30/6/07 Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calcuating annualised year to date income
Hi Mike
Thanks for that. I notice that the date calculation calculates a extra month. EG. 1/7/06 ~ 12/1/07 is 6 months, however if it appears that the formula is counting it as 7 months. If I take your formula =(C1/(DATEDIF(A1,B1,"m")+1))*12 I assume that the +1 is actually adding the extra mont, therefore if I remove the +1 it should give me the correct amount of months? I have tried this and t seems to now be working correctly. Thanks "Mike" wrote: Try this. =(C1/(DATEDIF(A1,B1,"m")+1))*12 Where A1 = start date of financial year B1 = payslip date C1 is earnings to date When entering this Excel will try to change the format of your cell to date so change it back to general. "Sam" wrote: Hello all I want to create a formula to annualise a persons income based on their gross financial year to date income. Assuming that the financial year begins on 1/7/06. The variables would be:- Financial year start date (1/7/06) Date of payslip Year to date gross income Result to calculate what the annualised income would be come 30/6/07 Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calcuating annualised year to date income
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create a self calcuating aged receivables? | Excel Discussion (Misc queries) | |||
how do i change the 2 year comparitive income stat. templ. to a 3 | Excel Discussion (Misc queries) | |||
excel how do I calculate income indexed each year for 15 years | Excel Discussion (Misc queries) | |||
formula for workbook showing daily income compared to goal income. | Excel Worksheet Functions | |||
How to I do integration in Excel XP (calcuating area under a curv. | Excel Discussion (Misc queries) |