ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Calcuating annualised year to date income (https://www.excelbanter.com/excel-programming/383126-re-calcuating-annualised-year-date-income.html)

Don Guillett
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




All times are GMT +1. The time now is 04:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com