Forum Discussion
Excel
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 s...
yes it's an assignment but not understanding what to use
What have you tried? What resources have you searched out (besides this one)?
I'll simply suggest that Excel contains a lot of what broadly can be called "date functions." You surely know of Google. Try a Google search. Here, I've done that part for you. I even took the next step and selected the top Google result.
Now it's up to you to experiment, learn by trial and error. That is the best way to learn.