how do I multiply dollars by networkdays for forcasting run rates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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.
 
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 (e-mail address removed)>
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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to multiply hours by a dollar amount 3
how can I multiply number of hours and minutes by hourly rate? 5
Multiply by a rate depending on the value 3
How do I multiply ALL CELL in spreadsheet at once by .5 ? 4
Query to lookup and multiply by exchange rates 1
How do I multiply cells? 4
How do I multiply dollars by time? 1
How do I multiply rate per hour by hours worked. 1

Back
Top