Special Engagement | Limited Availability
Available in June. Pre-Order Now! OR Visit the Bookstore at the Total Rewards Conference in San Diego June 6-8 to purchase a copy!
Understanding Executive Compensation & Governance: A Practical Guide, 3rd edition
Handbook of Compensation & Benefits Formulas, featuring Dianne Auld's Excel Tips, 2nd Edition
Can anyone share the formula you use to age data?
Survey data: x
Aged survey data: y
Annual aging percent: i
Survey date: SD
Current date: CD
y = x*(1plus ((CD-SD)/365)*i)
For some reason the plus sign isn't showing, so use that in lieu of where I put "plus"
There are sample calculations in the WAW website (click on link and scroll down to aging survey data for example).