Thread
:
Calcuating annualised year to date income
View Single Post
#
1
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Calcuating annualised year to date income
try
=C8/MONTH(NOW())*12
--
Don Guillett
SalesAid Software
"Sam" wrote in message
...
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett