Hello Users... please find herewith attached file.. Thanks
From India, Chandigarh

Attached Files
File Type: xls Excel-Formulae (1).xls (1.13 MB, 6570 views)
File Type: xls In-Out Log (EXCEL FORMULA OF LATE &EARLY).xls (20.5 KB, 5185 views)
File Type: xls MS Excel Formulas (1).xls (2.40 MB, 4100 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.

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.

From India, Badlapur
Sir,its really worked out,thanks for this useful post
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.
From India, Ahmedabad

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2021 Cite.Co™