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 sick dayslast month( 3rd, 4th and 26th,27th day of the month)
Can anyone tell me how to do that
3 Replies
Can anyone tell me how to do that
There are several people around here who could tell you how to do it. I could play around with the various date functions and figure it out, and that's what I'd have to do (i.e., I don't have a way clearly in mind, so it would take some experimenting).
BUT before I do (and hopefully before anybody else does), your request--the way it's worded--sounds exactly like a class assignment, something coming as part of a class you might be taking where YOU are the one who is expected to figure it out. Am I right?
If so, those of us who do much of the answering in this forum have agreed we're not here to do homework from start to finish. Helping you after you've struggled with it--and shown how you've tried to resolve it on your own--that's different.
So IF I'm right--that this is a homework assignment--could you first show us what you've tried so far? And if it's not, it still wouldn't hurt to show that you've put some effort into it, giving an idea of how you've arrayed your data, what formulas and functions you've tried.
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.
