# How to calculate an average based on number of days in a month

1. ## How to calculate an average based on number of days in a month

Hi everyone,

I'm trying to do something which should be quite simple (I would have thought) but can't find any resources online.

I want to calculate an average number of sales for a given month. It seems easy enough to do this if you have a specific date, but what if I only have the month. For instance, in column A I would have the month (row 1 - January, row 2 - February etc...) and in column B I would have the number of sales for that month. Then in column C I want the average, so number of sales / number of days in that month. Does anyone know how I can do this please?

Many thanks,

Ryan  Register To Reply

2. ## Re: How to calculate an average based on number of days in a month

Hi ,

One way with the date in A1 and the Sales in B1

Formula:  `Please Login or Register  to view this content.`

and if you have the month names in A1, January, February..etc and you want to SEE the names it would be better to put say 1/1/2020 in A1 as a date and format it to "mmmm"  Register To Reply

3. ## Re: How to calculate an average based on number of days in a month

=NETWORKDAYS(A1,EOMONTH(A1,0),holidays)
will give you the working days for each month - assuming you enter a date in A1 - ie 1/1/2020 and then format as MMM if you just want to display a month

now you have work days
then you can divide into B

=B1/NETWORKDAYS(A1,EOMONTH(A1,0),holidays)
should give the average for a workday in the month

Holidays are a named range for a table of when you have holidays in the month
no holidays just remove

=B1/NETWORKDAYS(A1,EOMONTH(A1,0))  Register To Reply

4. ## Re: How to calculate an average based on number of days in a month Originally Posted by Richard Buttrey Hi ,
Formula:  `Please Login or Register  to view this content.`
Could be more simple
Formula:  `Please Login or Register  to view this content.`  Register To Reply

5. ## Re: How to calculate an average based on number of days in a month

Ok so I have to use a date. Thanks for your help.  Register To Reply

6. ## Re: How to calculate an average based on number of days in a month

you can generate the date but February should be used with year because of 28/29 days.
A1: "January"
C1: =B1/DAY(EOMONTH(--("1"&A1&"2020"),0))  Register To Reply

There are currently 1 users browsing this thread. (0 members and 1 guests) 