Formula/Function

[RiaanKotze]

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

[#2]

@RiaanKotze 

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.

[#3]

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.              

[#4]

@RiaanKotze 

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.