Cactus1993
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!
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!
ASKER
Not really what I'm looking for here.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Excellent!
Thank you, Shums.
Thank you, Shums.
YTD.zip