Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i change the 2 year comparitive income stat. templ. to a 3 LeavingMI Excel Discussion (Misc queries) 1 May 13th 08 05:28 PM
Calcuating annualised year to date income Mike Excel Programming 2 February 13th 07 10:20 PM
Calcuating annualised year to date income Don Guillett Excel Programming 0 February 13th 07 03:24 PM
excel how do I calculate income indexed each year for 15 years zapie Excel Discussion (Misc queries) 2 March 28th 06 09:54 AM
formula for workbook showing daily income compared to goal income. tittytatbratt Excel Worksheet Functions 2 March 8th 05 09:47 PM


All times are GMT +1. The time now is 01:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"