employee count

  1. S

    Consecutive dates excel

    Hi, Having some problems trying to work out a formula to count incidents of absence. I have a report which gives me a list a column of names and next to it dates they have been absent. I want to work out the incidences of absence, e.g Johan - 01/01/2017, 02/01/2017, 03/01/2017, 10/02/2017 in...
    • sjurawan
    • Thread
    • absence absence periods absences date employee count
    • Replies: 2
    • Forum: Excel Questions
  2. S

    Measures for active and terminated employees

    Hi I have just started using PP and need help. I need to calculate the number of current and terminated employees for a given month. An employee is considered active at the beginning of a month if start date <= first day of month and termination date is blank or >= second day of the month...
    • serky
    • Thread
    • active employee count measures terminations
    • Replies: 5
    • Forum: Power Tools

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top