Link to home
Start Free TrialLog in
Avatar of Cactus1993
Cactus1993Flag for United States of America

asked on

Excel Formula for Calculating Full-Year Sales based on YTD Data?

Say my company is "X" number days into the year, and my sales are "Y".

I would like a formula to calculate my estimated annual sales based on the current date, calculating the number of days from the first day of the year (January 1) until today, and calculating the estimated end of year total sales based on year to date sales.

I would like to do this without entering an actual date anywhere in the spreadsheet, but instead based on my computer's internal time and date.

For example, if the date was today, February 23, there would have been 54 days since (and including) January 1, so if my sales today were $150,000, the formula return I am looking for would be $1,013,888.99.  ((($150,000/(todays date - January 1))*365)

Thanks!
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

Check out the formulas in the attached example
YTD.zip
Avatar of Cactus1993

ASKER

Not really what I'm looking for here.
ASKER CERTIFIED SOLUTION
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Excellent!
Thank you, Shums.