View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kelli Kelli is offline
external usenet poster
 
Posts: 10
Default annualize sales for remainder of year

I have a figure for YTD Sales and am trying to calculate estimated annualized
sales off of this. And, this will change monthly as sales managers update
their YTD sales to actual for the prior month end. Mathematically, the
formula would be: YTD Sales + ((YTD Sales/# whole months passed) (# whole
months remaining in year)).

Any suggestions?