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
|