Hi there! I am trying to calculate the average number of widgets sold per month based on the current day.
A1 = YTD Sale of Widgets
B1 = Average Monthly Production of Widgets
I am currently using the following formula in B1: =A1/(MONTH(TODAY()))
This worked fine in January, and would work fine on the last day of February, though it skewed the Average Sale of Widgets on February 1st to think there were 2 whole months to calculate the average....
I tried using the following formula in B1: =A1/(MONTH(TODAY())-1)
This skews results though that I've added for sales in the current month to think it should take the total YTD Widget Sales and divide by 1 (for only counting January since we are in February).
Is there a forumula that could calculate the Average Monthly Sales based on the Day of of the year? Thanks in advance for any help you can provide!
Bookmarks