Question about Microsoft Office Standard for PC

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

×

• 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

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

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

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### 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

### 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
Berkshire
SL6 4UB

Jun 21, 2012 | Fisher Price Ocean Wonders Cradle Swing

### 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

### 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

### 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

### 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

### 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:...

### 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

### 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

Mike

Nov 08, 2007 | Canon MP-25DV Calculator

## Open Questions:

#### Related Topics:

43 people viewed this question

Level 3 Expert

Level 3 Expert