Question about Microsoft Office Standard for PC

1 Answer

Excel cell A1=yes cell B1=1. Then tried to calculate monday to friday excluding bank holidays. Seem to have lost the plot. Any help would be great even if you could point me in the right direction been trying for over 4 hours. Many Thanks HYBFS

Posted by on

  • hybfs Sep 13, 2007

    If Cell A1 says Yes need in Cell B1 to calculate the yes answer to = 1 so all yes answers can be calculated.

×

Ad

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 12 Answers

Hi HYBFS, Please give me a little more detail of what you are trying to achieve from this formula and I will be able to assist you. Thanks and regards DeltaC

Posted on Sep 13, 2007

Ad

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.
Good luck!

Posted on Jan 02, 2017

Ad

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

1 Answer

How do I open battery area of our cradle swing?


We would recommend you speak with Fisher Price

To speak to an advisor call us on 01628 500303 during normal business hours (excluding bank holidays):

Monday to Thursday: 10am to 4pm
Friday: 9am to 1pm
Alternatively, you may wish to write us at:

Mattel UK Ltd
UK Consumer Response
Mattel House
Vanwall Business Park
Vanwall Road
Maidenhead
Berkshire
SL6 4UB

Please include a daytime telephone number on your correspondence.

Jun 21, 2012 | Fisher Price Ocean Wonders Cradle Swing

1 Answer

Eror code 5200 or p08


Issue: ERROR: Error code 5200 appears on the computer screen
--------------------------------------------------------------------------------
Solution: The MP250 may require repair
Unfortunately, the issue you describe seems to indicate that your product requires repair service. If you feel your product might require service, a Technical Support Representative will be happy to answer any questions you may have and explain the service options available to you. You can contact us through the email link or phone numbers listed below.
Obtain Support by Email
For toll-free technical support*, please call 1-800-OK-CANON (1-800-652-2666) during regular business hours (currently Monday-Friday 10:00 a.m. - 10:00 p.m. Eastern Time, excluding holidays).
* There will be a pay for support charge if your product is out of warranty (see next section, below).

Toll-free TDD Support Line for the Hearing Impaired is available Monday - Friday (excluding holidays) at 1-866-251-3752

Technical Support is available for Customers in Canada at 1-800-OK-CANON
If your printer is no longer under warranty :

For toll-free technical support*, please call 1-800-OK-CANON (1-800-652-2666) during regular business hours (currently Monday-Friday 10:00 a.m. - 10:00 p.m. Eastern Time, excluding holidays).
*Pay for support is required on all units outside their original warranty, unless covered by a Canon Extended Service Plan. If it is determined that there is a hardware failure, you have the option to purchase a new or refurbished product from our current product line, which includes units with Canon?s new ChromaLife inks, PIXMA Technology, a limited manufacturer?s warranty, free next business day shipping and discounted pricing. If you elect to take this option, the pay for support charge will be canceled.

Jan 18, 2011 | Canon Office Equipment & Supplies

3 Answers

Pls help to write an excel formula to display date, thanks! Cell A1 input a date - 1 Sep 10, Cell B1 write a formula to calculate & display the date which = (A1 + 14 days but if the result is a...


This is too complicated for a help site like this, you are going to want to consult an excel forum, or some excel professional in your area. This is far beyond the scope of what you can expect for $15, which I'm sure you now realize after 10 days of trying.

Thanks
Tim

Sep 26, 2010 | Microsoft Excel for PC

1 Answer

Converting date of a month to last working day of the month


use the below formula to get the date of the LWD (Monday thru Friday) of the month.
Assumed that if the date in cell A1 is 6-May-2005. then formula will be
=DATE(YEAR(A1),MONTH(A1)+1,0)-(MAX(0,WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,0),2)-5))

Jan 30, 2009 | Microsoft Excel for PC

1 Answer

How do I calculate Turn around time in excel excluding sat & sun for 2009


It sounds like you want to determine the number of work days between two days? Use the NETWORKDAYS function. For example, if A1 is 1/4/09 and B1 is 2/4/09, =NETWORKDAYS(A1,B1) will be 23

Dec 18, 2008 | Microsoft Excel for PC

2 Answers

Formula for calculating the days beween months


for example, cell A1 has date (01-01-2008) and cell A2 has current date (08-24-2008) and cell A3 shows total days, is that you want to know? if yes, apply formula as under...

cell A3......(properties set as General to show digits)................ =SUM(A2-A1)

Aug 25, 2008 | Microsoft Office Professional 2007:...

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

1 Answer

How to insall ribbon


Search Canon's website (www.canonusa.com) for the manual.
I did a quick look but didn't find it there. You might have to call
Canon:

Canon USA offers a full range of customer technical support* options:
  • Toll-free live technical support** Monday - Friday 8:00 a.m. - 8:00 p.m. EST at 1-800-828-4040
  • The location of the ASF nearest you for carry-in service at 1-800-828-4040
  • Toll-free TDD Support Line for the Hearing Impaired Monday - Saturday (excluding holidays) at 1-866-251-3752
  • Technical Support for Customers in Canada at 1-800-OK-CANON

or email link
http://www.usa.canon.com/consumer/controller?act=ModelInfoAct&tabact=DownloadDetailTabAct&fcategoryid=349&modelid=9796#SupportDetailAct

Mike

Nov 08, 2007 | Canon MP-25DV Calculator

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

Related Topics:

43 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2983 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18424 Answers

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

Answer questions

Manuals & User Guides

Loading...