How to Calculate Average Daily Sales

RL Productions/Digital Vision/Getty Images

Sales figures can vary wildly on a daily, weekly and monthly basis. Calculating average daily sales helps a business owner budget expenses and forecast future sales. For best results, calculate average daily sales in a sales tracking spreadsheet. A spreadsheet program makes it easy to catch errors and manipulate sales data.

Calculating Average Daily Cells

Maintain your daily sales in a sales tracking spreadsheet. Enter daily dates in the first column and corresponding daily sales in the second column. Use the average function to calculate the average daily sales for the period in question. For example, say that you have two months worth of sales data in cells B1 to B61. Type "=Average(B1:B61)" into the formula bar of a blank cell. The resulting number equals the average daily sales for the period.

References

About the Author

Based in San Diego, Calif., Madison Garcia is a writer specializing in business topics. Garcia received her Master of Science in accountancy from San Diego State University.

Photo Credits

  • RL Productions/Digital Vision/Getty Images