Calendar - 6 Working Days

If I make a bit more simpler; What I am looking for is,

In the attached Excel workbook; if you look at the Calendar View worksheet, Cell N9 is in grey; which means it is a Holiday.. I want Saturdays to be Working days. So that the "Key statistics" section will show the correct number of Working days.(LMNO 26,27,28)

I hope my explanation helps you to understand my question better.

try this in L26

=NETWORKDAYS.INTL(DATE($AN$5,1,1),EDATE(DATE($AN$5,1,1),12)-1,11)

And L30
=NETWORKDAYS.INTL(DATE($AN$5-1,1,1),EDATE(DATE($AN$5-1,1,1),12)-1,11)

Originally Posted by PRINCEOFANDROMEDA

Now, there are a few Company Holidays (Go to the "Settings" Worksheet tab) ; I think the above forumlae you given, doesn't consider this.

Nor does the original formula you posted.
You just need to add the holidays list to the formula
=NETWORKDAYS.INTL(DATE($AN$5,1,1),EDATE(DATE($AN$5,1,1),12)-1,11,lstHolidays)
=NETWORKDAYS.INTL(DATE($AN$5-1,1,1),EDATE(DATE($AN$5-1,1,1),12)-1,11,lstHolidays)

Althoug it won't make a difference to the 2nd one (for last year) because you only have this year's holidays in the list.

Originally Posted by PRINCEOFANDROMEDA

Also, still in the Calendar, SATURDAY is shown as holiday (you can see in Gray color at Column N, Column U and so on). This has to be in BLACK and which means Working days.

Change your last conditional formatting rule (with Grey text)
From
=OR(H$8="S", COUNTIF(lstHolidays, H9)>0)
to
=OR(H$8&I$8="SM", COUNTIF(lstHolidays, H9)>0)

Perfect ..!! That did it.

Thank you so much for the help mate.

Thanks Jonmo.

Great, glad to help

Hey .. I was looking for some help in the same excel sheet - Employee attendance tracker.
I want to make all days working - 7 days working as I have different employees working on different days of the week.
How can I modify the formula to get it working for me ?
Any suggestions ?

Shwetapolepally I am trying to do the same thing! Did you ever figure out how to change the working days under Key Statistics?

Did anyone work out how to change the dates to UK variant?

I searched the whole net for this solution !! and this is the only post that talked about it :D.

I really need to edit this useful calendar formula to make the vacation days set on "Friday and Saturday: not only their color conditions .. been trying so long with it and I'm kind of new learner in Excel formulas .. can you help me please ?? please ?? it's kind of deadline job thing

please

any luck on getting this solved? I am still having a hard time doing so

Dear Support,

could you please provide me with excel file for "Employee attendance tracker" with the following requirements:

1- my off day only Friday and I want to make the Saturday counted as a working day even in annual leave.
2- want the annual leave counted the Saturday as a working day in leave.
3- showing only the Friday with the Grey Colour and the rest should be black.

Awaiting to attached to me this file

appreciated your support

Dear expert,

I was working "EMPLOYEE ATTENDANCE TRACKER" to tackle the attendance of my team members but i stuck in a problem that in "Employee Leave Tracker" Column F not counting a day (25-July-2015) as a Sick Leave highlighted in yellow color ?
But the color "Blue" shown in "Calendar View" also not counting the "KEY STATISTICS" area, # of Days Sick = 0, however it should be "1".

Sorry, I didn't find any button to attach my file ?

Hi

Can you attach the template for 6 working days (Saturday being working day) am having the same problem you had. Thank you.