Question about Microsoft Office Professional 2007 Full Version for PC

1 Answer

Work day would like to know the formula for work days, Saturday & Sunday to be excluded as holidays, eg. July 01 to July 10 = work days

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that hasĀ over 10 points.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 13 Answers

Hi Chinnu,

For this you will have to install an Add-in called Analysis Tool Pack.

Kindly follow the below instructions:

1. Open Excel Options (Menu-Excel Options)
2. Click on Add-Ins on the side pane of the Excel Options Window
3. Check to see if Analysis ToolPak is in Inactive application add-in list.
4. If is not, proceed to Step 7
5. If it is in the inactive application add in list, Select Excel Add-ins against Manage and click on "Go"
6. In the add-ins menu check Analysis ToolPak and Analysis ToolPak VBA and click OK
7. Use this formula to find the number of work days excluding Saturday & Sunday in a month

=NETWORKDAYS(start_date,end_date, [Holidays])

In your case give the start date as 1st July and end date as 10th July and Holidays as 0 or 1 (doesn't matter). The answer it will return will be 8 days.

Trust the above helped.

Posted on Jul 24, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Workday function in excel formulas


The WorkDay Function returns a number that's the serial date that is the indicated number of working days from a given date (the starting date). Working days EXCLUDE weekends and any dates identified as holidays. Use WORKDAY to exclude weekends or holidays when you calculate invoice due dates, expected delivery times, or the number of days of work performed.
The Syntax is:
=WORKDAY(start_date,days,holidays)
where:
- start_date is in Date format (and can be a calculated value);
- days is a number of elapsed days after start_date (can be calculated, can be negative to indicate a date BEFORE start_date);
- holidays is an array of holidays you can specify if desired.

May 01, 2014 | Microsoft Excel for PC

2 Answers

To charge


Men\'s Grooming / Norelco

1-800-243-3050

Monday - Saturday 9:00 AM - 9:00 PM EST

Sunday 9:00 AM - 6:00 PM EST

Excluding Major Holidays

good luck

Apr 19, 2014 | Philips arcitec 1060 Electric Shaver

1 Answer

Need 1-800 number for philips breadmaker to order parts


You're going to want to call the number below: Good luck! William
General Support
1-888-744-5477 Monday - Saturday 9:00 AM - 9:00 PM EST Sunday 9:00 AM - 6:00 PM EST Excluding Major Holidays

Feb 28, 2011 | Vacuums

1 Answer

Where can i call and speak w/someone re: norelco shaver 7735x


Norelco: 1-800-243-3050 Monday - Saturday 9:00 AM - 9:00 PM EST Sunday 9:00 AM - 6:00 PM EST Excluding Major Holidays

Jan 21, 2011 | Norelco 7735X Electric Shaver

1 Answer

Ipod light is blink and not be a start. .


1-888-744-5477 Monday - Saturday 8:00 AM - 11:00 PM EST Sunday 9:00 AM - 6:00 PM EST Excluding Major Holidays is the number for customer service

Nov 28, 2010 | Philips SA3025/37 Flash MP3 Player

1 Answer

Is there any service center in nagpur m.s.india for htc viva touch


Name: Kaizer Telecom
Address: Shop no-42Jia jawan market,Near apna bazar,sec-17,vashi
Tel: 022-67919116, 67912065
Office Hours: Monday to Saturday : 10:00a.m. to 6:00 p.m.
2nd Saturday, Sunday and Public Holiday - Closed


Name: Tanuja Telecom
Address: shop no 02, Vishwakarma Bldng no.05, Ambali road, vasai west
Tel: 0250-6588494
Office Hours: Monday to Saturday : 10:00a.m. to 6:00 p.m.
2nd Saturday, Sunday and Public Holiday - Closed


Name: Salora Int'l Ltd
Address: 384,dongre bldg,lamington road
Tel: 23886570/23861930
Office Hours: Monday to Saturday : 10:00a.m. to 6:00 p.m.
2nd Saturday, Sunday and Public Holiday - Closed


RT Outsourcing Services LTD.
Mahajan Compound, Behind Union Bank,LBS Marg, Vikhroli
(W),Mumbai -400079
(+91-22-65247595;92)
Monday to Saturday : 9:30a.m. to 5:30 p.m.

Jul 26, 2010 | HTC Touch Viva Cell Phone

1 Answer

What address i need to go to repair my compaq pc,in hongkong


Phone: Hong Kong (852) 2802-4098 Macau (853) 0800366 Hours of operation: Monday to Friday, 9:00 am to 6:00 pm
Saturday, 9:00 am to 1:00 pm
(excluding Sunday & public holidays)
call the customer care they will update you.

Jun 07, 2010 | Computers & Internet

1 Answer

Is it possible to purchase a new remote ?


contact philips customer care:
General Support
1-888-744-5477 Monday - Saturday 8:00 AM - 11:00 PM EST Sunday 9:00 AM - 6:00 PM EST Excluding Major Holidays I could not locate a model # for the remote Cheers!

Feb 14, 2010 | Philips Audio Players & Recorders

1 Answer

To Whom It May Concern, In last july, we have bought 2 Philips DVD Micro Theater systems at Sharper Image. One works beautifully and we just love it! Since the first time we turned it on, the other...


Contact Philips service , they will check your product number and book you an appointment at the nearest service shop.
See How to Service

Here is the contact:


1-888-744-5477
Monday - Saturday 7:00 am - 11:00 pm EST
Sunday 8:00 am - 11:00 pm EST
Excluding major holidays
or see Contact Us




They may ask you to register product online here first: Register your product

Sep 10, 2008 | Philips Televison & Video

1 Answer

Remote


I have the codes for a PMS435, but you might be better off calling Philips, press the option for remote controls:
1-800-835-3506
Monday-Friday 10:00 am - 10 pm EST
Saturday and Sunday 12:00 pm - 9:00 pm EST
Excluding major holidays

Mar 17, 2008 | Televison & Video

Not finding what you are looking for?
Microsoft Office Professional 2007 Full Version for PC Logo

280 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18386 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...