View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Calcuating annualised year to date income

Assuming constant pay.

365/(payslip date - start of year date) * Year to date gross income

or pay per payperiod * number of pay periods

--
Regards,
Tom Ogilvy


"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