George,

Format cells A1, B1, C1 as "Date".
Enter the first day of the month in A1 using a complete date, such as 01/01/2006
Enter the last day of the month in B1, such as 01/31/2006
Enter any extra non-working days in C1, such as 01/16/2006 ( that's today)

The syntax is "=NetWorkDays" not NetWorkingDays", so...
"=NETWORKDAYS(A1,B1,C1)" returns 21

Multiple that by your average daily sales = "a profitable business?"

How come no picture with your bio on the InternetMovieDatabase (www.imdb.com)?

Regards,
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"George Cahill" <George
wrote in message
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.