"Kelli" wrote:
I have a figure for YTD Sales and am trying to
calculate estimated annualized sales off of this.

Assuming a calendar year, if A1 contains YTD sales and A2 contains YTD date,
then:

=12*A1/month(A2)

If YTD is based on a fiscal year that is different from the calendar year,
replace month(A2) with A2, where A2 contains the fiscal month number
corresponding to the YTD sales.


----- original message -----

"Kelli" wrote:
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?