How to Calculate Average Daily Sales

by Madison Garcia ; Updated September 26, 2017
Young woman sales clerk, serving female customer sniffing cosmetics, side view

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.

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
Cite this Article A tool to create a citation to reference this article Cite this Article

Here's a Calculator to Help You