Jul 07 2020 12:24 AM
Good morning all!
Im in need of assistance please.
Im working on a attendance register.
Need the following:
- A formula or function that will count the employees per day. So in other words it keeps showing the present dates current employees at work
Example: Today is the 7th June and there are 12 Employees at work then it pulls that 12 employees and so for the 8,9 and 10 etc.
I will share the register if needed.
Kind Regards
Jul 07 2020 12:29 AM
To count Excel has to know is employee at work or not at any given date. How your data is organised? Perhaps you may illustrate with sample file.
Jul 07 2020 12:54 AM
All absenteeism criteria are in a drop down according to the employee and date.
Example: 7st June
Johan Rabie (Criteria, in drop down)
The drop down will specify if the employee is present, awop, sick, annual leave etc.
Jul 07 2020 02:04 AM
If columns with drop-down are for each date, you may count for each such column as
=COUNTIF(dateColumn,"present")
where on place of dateColumn shall be concrete range.