Question about Microsoft Excel for PC

I need to calculate the turn around time in excel excluding saturday's & sunday's for the year 2009 (jan - dec).... how do I do that?

Ad

Dpprash,

I guess you mean the number of weekdays (or working days) excluding Saturdays and Sundays. So start a spreadshhet and put the start date (01/01/2009) in A2 and the end date (31/12/2009?) in B2.

Then paste the formula below into C2:

=B2-A2-2*INT((B2-A2+WEEKDAY(A2,3))/7)-MAX(0,WEEKDAY(B2,3)-4

better-swiss

Posted on Dec 19, 2008

Ad

I dont understand this formula

Posted on Apr 08, 2009

Ad

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

Every borrower can calculate your loan EMI with three methods -

**1. Formula Based:**you can calculate your loan EMI with the help of given formula-

E = P x r x (1+r)n / ((1+r)n - 1)

where,

E = Each month payable EMI

P = Principal loan amount

r = Rate of interest

n = Duration of the loan

**2. Excel Based:**

You can also calculate your loan EMI with the help of excel sheet. But before calculating loan EMI, you need to set the above formula in excel sheet.

**3.Online EMI calculator:**

You can calculate your loan EMI with the help of online business loan EMI calculator . EMI calculators can calculate your loan EMI very easily without any cost.

E = P x r x (1+r)n / ((1+r)n - 1)

where,

E = Each month payable EMI

P = Principal loan amount

r = Rate of interest

n = Duration of the loan

Feb 21, 2018 | The Computers & Internet

Try this: =IF(B13+(B13*B$7/12-B$10)<0,0,B13+(B13*B$7/12-B$10))

Jul 07, 2015 | Microsoft Excel for PC

Check to make sure you have the proper value set for payments-per-year.

Mar 27, 2009 | Texas Instruments BA-II Plus Calculator

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

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

=10000*(1+0.96)^12

=10000*(1+0.10)^18

=10000*(1+0.10)^24

=10000*(1+0.10)^18

=10000*(1+0.10)^24

Dec 02, 2008 | Microsoft Office Professional 2007 Full...

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)

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

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

First type in 31-Aug-1974 in Cell = C1

then in the calculation cell use this formula

=text(C1,"dddd")

this yields Saturday in text

then in the calculation cell use this formula

=text(C1,"dddd")

this yields Saturday in text

Jul 29, 2008 | Microsoft Excel for PC

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.

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.

Jul 23, 2008 | Microsoft Office Professional 2007 Full...

I have created a spreadsheet for you to a) use and b) to learn from.

It is an Automated spreadsheet (as they should be) which calculates the number of minutes in a working week or month and calculates the average time per email giving Daily, Weekly and Monthly Outputs. It takes into account Public Holidays (or for time off). You can use the Output to create Graphs etc to visually display the Output.

It also allows you to calculate a Part Month average.

I have displayed it as it was CONSTRUCTED and as it would be USED.

The As Used worksheet is Protected and the only Inputs that can be done are in the Green Boxes (also the Saturday and Sunday boxes but you will need to Unhide the Validation List to include these and then to add 2 more columns titled Is Saturday? and Is Sunday? with the appropriate If Statement.

To unprotect the sheet go to Tools - Protection - Unprotect. There is no password so leave this blank.

All the workings are still there, the columns are just Hidden. To Unhide them, highlight the columns to the left and right of the hidden columns, click on Format - Columns - Unhide. To hide them again, highlight the columns that you want hidden, click on Format - Columns - Hide.

The LOGIC used (as in Functions) may seem complex but if you read the Descriptions in the first row you should be able to work out what and why it was done that way. Click on a cell to see what Function was used where.

You said that your spreadsheet was becoming a real mess, well I have created a monster for you (but not a mess).

I have uploaded the file to here:

http://users.tpg.com.au/lesliecl/

Hope this gives you the push to really start using Excel.

It is an Automated spreadsheet (as they should be) which calculates the number of minutes in a working week or month and calculates the average time per email giving Daily, Weekly and Monthly Outputs. It takes into account Public Holidays (or for time off). You can use the Output to create Graphs etc to visually display the Output.

It also allows you to calculate a Part Month average.

I have displayed it as it was CONSTRUCTED and as it would be USED.

The As Used worksheet is Protected and the only Inputs that can be done are in the Green Boxes (also the Saturday and Sunday boxes but you will need to Unhide the Validation List to include these and then to add 2 more columns titled Is Saturday? and Is Sunday? with the appropriate If Statement.

To unprotect the sheet go to Tools - Protection - Unprotect. There is no password so leave this blank.

All the workings are still there, the columns are just Hidden. To Unhide them, highlight the columns to the left and right of the hidden columns, click on Format - Columns - Unhide. To hide them again, highlight the columns that you want hidden, click on Format - Columns - Hide.

The LOGIC used (as in Functions) may seem complex but if you read the Descriptions in the first row you should be able to work out what and why it was done that way. Click on a cell to see what Function was used where.

You said that your spreadsheet was becoming a real mess, well I have created a monster for you (but not a mess).

I have uploaded the file to here:

http://users.tpg.com.au/lesliecl/

Hope this gives you the push to really start using Excel.

Apr 04, 2008 | Microsoft Excel for PC

Hi,

Since you are asking for the formula, it depends where your values are (cell). Please refer to the example below.

Good luck and kind regards.

Since you are asking for the formula, it depends where your values are (cell). Please refer to the example below.

Good luck and kind regards.

Dec 09, 2007 | Computers & Internet

Jan 28, 2016 | Microsoft Excel for PC

Dec 12, 2013 | Microsoft Excel for PC

Jul 23, 2013 | Microsoft Excel for PC

3,641 people viewed this question

Usually answered in minutes!

I need to compute for the turn around time in hours including saturdays and sundays.

What if there is a holiday in between?

×