how do I multiply dollars by networkdays for forcasting run rates

G

George Cahill

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.
 
B

bpeltzer

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
 
G

Govind

Hi,

The problem is with your logic. To arrive at the projected sales in
dollars for the month, you should be using

=(Month to date sales/Month to date business days) * Total no. of
business days in the month

so you might have to use two networkingdays function. First one to
arrive at Month to date business days and next one to arrive total
business days in a month.

Regards

Govind.
 
J

Jim Cone

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 [email protected]>
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.
 
J

Jim Cone

It does have several pictures of Ashley Judd.
However there are none for Jim Cone or Bob Phillips...go figure.



Not exactly A-league!
To many pics are missing from IMDB, annoying bwhen you are looking someone
up.
 
Top