Microsoft Office Standard for PC Logo

Related Topics:

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 hybfs 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. Add

×

Loading...
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.
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.
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
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))
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
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
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
Not finding what you are looking for?

49 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Ekse

Level 3 Expert

13435 Answers

David Shaub

Level 3 Expert

2991 Answers

Mandeep  Singh
Mandeep Singh

Level 3 Expert

1184 Answers

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

Answer questions

Manuals & User Guides

Loading...