#### Related Topics:

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.

×

Ad

## 1 Answer

### Anonymous

• 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

## Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video.

×

Loading...

## Related Questions:

0helpful
1answer

### I want to renew my psira certificate

Contact PSIRA, presumably in South Africa and not in the United States, Great Britain, or Canada.

https://www.psira.co.za/psira/index.php/publications/registration-unit

Contacts:
Primary: 086 10 PSiRA (77472)
Helpdesk: 086 133 3850
International Calls Only: +27 12 337-5500
Email: [email protected]
Office hours are 07:30 - 16:00
Monday to Friday
Excluding holidays

Regards.
May 19, 2019 • Computers & Internet
0helpful
1answer

### 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
0helpful
1answer

### 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.
44helpful
3answers

### 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
1helpful
1answer

### 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
0helpful
1answer

### 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
0helpful
2answers

### 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)
0helpful
1answer

### 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
0helpful
1answer

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

49 views

## Ask a Question

Usually answered in minutes!

Level 3 Expert

13435 Answers

Level 3 Expert

2991 Answers

Level 3 Expert

1184 Answers

Loading...