Hi Everyone,
Excel noob here. I'll try to explain this as best I can.
I've created a formula that allows me to predict gross revenue in a given month based on where I am at any particular day in the month.
For example, if I'm on day 10 of a 30 day month and I've generated $1000 in revenue so far in the month the formula will tell me that I'll be at $3000 on day 30.
The problem is that once the month is over the formula resets and keeps going, skewing the data. I'm hoping to update the formula so that it knows to stop running after the last day of the month and stays at the final number.
Here's my current formula: =SUM(N5)/day(TODAY())*DAY(EOMONTH(K1,0))
N5 = total revenue in the month so far
K1 = Month (in this case April 2017)
Please let me know if this makes sense or if further info would be helpful. Thanks!
Bookmarks