Order pace formula

  • Thread starter Thread starter brianwa
  • Start date Start date
B

brianwa

I need help on a formula. I wrote this formula to basically make
prediction as to where we would finish the month based on sales t
date. The problem I'm having is that the predicted number is highe
that what it should be.

=SUM(NETWORKDAYS($C$4,$AG$4,AL6:AL9)-DATEDIF($C$4,$AJ$3,"d"))*AI7

cell AJ3 contains today's date. AI7 has the sales to date.
Any help is greatly appreciated.

Thanks in advance
B
 
Wouldn't you have to figure out what the average sales per day is?

ai7/(number of days in year to date)

Then use that for multiplier in your number of days left formula. (then add
back the sales to date).

But this is just a guess.

===
And I don't think you're gaining anything by including =sum().
 
Back
Top