Hr Personnel Manager
Admin Manager
Admin Manager

Hello Users... please find herewith attached file.. Thanks
21st June 2014 From India, Chandigarh

Attached Files
Membership is required for download. Create An Account First
File Type: xls Excel-Formulae (1).xls (1.13 MB, 5930 views)
File Type: xls In-Out Log (EXCEL FORMULA OF LATE &EARLY).xls (20.5 KB, 4443 views)
File Type: xls MS Excel Formulas (1).xls (2.40 MB, 3568 views)

Formulae Xls is wonderful. This is really help ful.
I am having one query. I have an attendance sheet . Where I have marked Weekly off of a month as W.and if a employee is on leave I mark it as L. Using countif i take the number of weekly off and leave. Now my question. If there is an L before and After W. i.e. "L" , "W" and "L" i want the count of L to be Three and it should not take consider W in Countif.of W.
23rd January 2017 From India, Thane
Dear sir,
i'm working currently working at dombivli with dns bank as a assistant manager.
My english communication is a little bit weak.
So, it's my request to you to please suggest me a proper solution to said problem.
4th February 2017 From India, Badlapur
Sir,its really worked out,thanks for this useful post
17th September 2017 From India, New Delhi
we have more than 45 nos of employee and we need to calculate which employees are coming late every day and in a month how many days coming late. after calculating late coming days in a month to deduction salary for the same.
9th February 2019 From India, Ahmedabad
Add Reply Start A New Discussion

Cite.Co - is a repository of information created by your industry peers and experienced seniors. Register Here and help by adding your inputs to this topic/query page.
Prime Sponsor: TALENTEDGE - Certification Courses for career growth from top institutes like IIM / XLRI direct to device (online digital learning)

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2019 Cite.Co™