What's your formula so far? Without more information, it's hard to tell if
the problem is math or Excel. In general, you would project full-month sales
as MTD Sales * (business days in full month) / (business days MTD).
--Bruce

"George Cahill" wrote:

I'm using the =networkingdays(a1,b1,holidays) to business days for the
month. I want to multiply the Month To Date sales in dollars by the results
of the above formula to generate the projected sales in dollars ($) for the
month.

When I try it now it give me an un-godly number in the millions when I know
that the results should be in the $150,000.00 range. Where did I go wrong?
What did I leave out? Set me straight & earn the thanks of a grateful old
actor.