Calendar with 7 working days

First of all please have a look at the attached Excel file. This is an Employee Leave Tracker.
I am using Office 365. The template only has 5 working days in it, but I need to set 7 working days (Saturday & Sunday also working day).

Wondering, how to get this working without spoiling the functions. I am very newbie to Excel, tried a lot by google search, But no luck. Also the date format is in US , need to change to UK without disrupting the Formula/Functions.

I will appreciate if:

1) the formula can be changed to ensure all 7 days are considered working days as different employees have different weekly off;

2) there are some common yearly holidays for all (like new years eve, christmas, Diwali, etc.);

3) the Calendar view has the Saturday & Sunday as normal and not in Grey; and

4) the Formula in the Key Statistics under the Calendar View is correct to include Saturday and Sunday as working days and also takes into account common holidays.


Thanks in advance,

Prashant

Just use

End Date - Start Date + 1

instead of NETWORKDAYS

Ron,

Each employee work 6 days a week and will have different weekly holidays.

I am a very basic excel user and so have no idea how to get this done. Will appreciate if you can get this done for us and share step by step as to how I achieve this.

Many thanks Ron. I am sure this will work!!!