Formula/Function

%3CLINGO-SUB%20id%3D%22lingo-sub-1505977%22%20slang%3D%22en-US%22%3EFormula%2FFunction%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1505977%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20morning%20all!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIm%20in%20need%20of%20assistance%20please.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIm%20working%20on%20a%20attendance%20register.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENeed%20the%20following%3A%3C%2FP%3E%3CP%3E-%20A%20formula%20or%20function%20that%20will%20count%20the%20employees%20per%20day.%20So%20in%20other%20words%20it%20keeps%20showing%20the%20present%20dates%20current%20employees%20at%20work%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%3A%20Today%20is%20the%207th%20June%20and%20there%20are%2012%20Employees%20at%20work%20then%20it%20pulls%20that%2012%20employees%20and%20so%20for%20the%208%2C9%20and%2010%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20will%20share%20the%20register%20if%20needed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20Regards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1505977%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

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

3 Replies
Highlighted

@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.

Highlighted

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.              

Highlighted

@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.