Need excel answer for this

[mklearn]

Create a Calendar for the employee, where you calculate total working days in last 1 month Consider weekend as Saturday and Sunday, And all the national Holidays This Employee has taken 1 CL and 2 sick dayslast month( 3rd, 4th and 26th,27th day of the month)

 

[vletm]

mklearn
Could You create a sample Excel-file which has Your needed features?
... including some all the national Holidays.
Could You verify Your the last sentence ... 1CL and 2 sick days ... with four Your given days?

 

[Debaser]

Also here: https://www.mrexcel.com/board/threads/need-excel-ans-for-my-assignment.1225631/

 

[vletm]

mklearn
Please reread Forum Rules

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

• Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
• If you do cross-post, please put that in your post.
• Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.

 

[mklearn]

mklearn
Could You create a sample Excel-file which has Your needed features?
... including some all the national Holidays.
Could You verify Your the last sentence ... 1CL and 2 sick days ... with four Your given days?

Create a Calendar for the employee, where you calculate total working days in last 1 month Consider weekend as Saturday and Sunday, And all the national Holidays This Employee has taken 1 CL and 2 sick dayslast month( 3rd, 4th and 26th,27th day of the month)

 

[mklearn]

Create a Calendar for the employee, where you calculate total working days in last 1 month Consider weekend as Saturday and Sunday, And all the national Holidays This Employee has taken 1 CL and 2 sick dayslast month( 3rd, 4th and 26th,27th day of the month)

Here is sheet

 

[vletm]

mklearn
# You skipped case Cross-posting - why?
... Here one link for You to read

A Message to Forum Cross Posters

Do you know why you're here? If you have been pointed to this page, it is not because someone is mad at you, but rather because we want to curb your posting habits before people start ignoring your posts. Online … Continue reading →

excelguru.ca

# Your sheet - Did You read my #2 reply?
... You basically sent an empty sheet - should that show something for others than You?

 

[pecoflyer]

In general, helpers here are not so keen on simply doing your homework for you. However, if you have attempted the exercise and made some progress we are more likely to then help with any particular points that you get stuck on.