Forecast Sales - Divide sales by completed days & multiple by days in month

[Anonymous]

I'm trying to figure out how to forecast sales for the current month based on the average dailys sales that have been completed. 

For example, let's say total sales have been $100,000 thru 14 days in April. I need to divide $100,000 by 14 and then multiple it by 30 (total days in the month of April), so that the Forecasted Sales are $214,285. 

Thank you for your help!

[edhans · Accepted solution]

Try this:

Forecasted Sales = Sales[Gross Sales]/DAY(TODAY()) * DAY(EOMONTH(TODAY(),0))

This is a calculated column. It takes sales, divides by the day number of today, then multiplies by the day number of the last day of the current month.