Count number of days minus Friday and or Saturday

**aj34321** · 01-21-2013, 03:03 PM

Dear All,

I would like to calculate number of days minus friday and or saturday between two given dates in excel.

Secondly, in my excel file i have around 30 to 40 worksheets, now I want to display the name of worksheet in a cell A1 in each worksheet. Below formula is written in A1 of each worksheet and what happens is, when i edit formula and press return key, it fetches the displayed name of the worksheet and next when i move to other worksheet, even this has the same value in A1 as of previous worksheet.

What I want is: Sheet1!A1 should display Sheet1, Sheet2!A1 should display Sheet2..

Formula: =MID(CELL("filename"),FIND("]",CELL("filename"))+1,30)

Request your expert advice on both of my queries.

Rgds, Anil

**6StringJazzer** · 01-21-2013, 04:59 PM

I am addressing both your questions but in the future you should open two threads, because these questions are completely unrelated.

Dates
This formula shifts NETWORKDAYS to work with a Friday/Saturday weekend:

=NETWORKDAYS(C2+1,D2+1)

(In Excel 2010 NETWORKDAYS.INTL was introduced allowing this to be built in.)

Sheet Names
I used your formula in my own workbook and it worked perfectly. I don't see a problem. Can you attach your file?

**aj34321** · 01-21-2013, 05:29 PM

Thanks for the formula.. I have attached excel file sample.xlsx.

In this file, if i try to bring sheet1 name and move to sheet two refresh the value, you will notice all the tabsheets will have same name.

Rgds, ANil

Moderators Note:

As per Forum Rule #12, please don't quote whole posts unless necessary-- it's just clutter...Thanks.

**Tony Valko** · 01-21-2013, 06:05 PM

For the sheet name, you have to include a cell reference:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,31)

The file must have been saved and given a name before this will work.

**6StringJazzer** · 01-21-2013, 06:18 PM

I confirmed your problem and I have no idea what is going on. When I tried it on my own file, each sheet looked fine but I did not go back and look at Sheet1 but it indeed did say Sheet3.

I have started a new thread with this question on your behalf. I suggest you subscribe to it to see any answers that may come up.

I did not preview so I didn't see Tony Valko's answer before I posted, but I confirmed it. I do not know why because the range reference is an optional argument, but that does solve the question.