Excel Help Thread Number Twelvety 8

[libero]

We have an absence problem at work and they are trying to use excel to count the instances of absence from a list of dates.

1 day off is an instance but if you have 20 days off its still just one instance, the dates of absence are in Column E and the Data goes upto Column I.

Preferably a formula to get it to work and obviously not counting weekends, have tried Google and it seems to be a common problem but the solutions I have seen are from years back and mean adding in new columns to input data on a weekly basis and then count that data??

That's fine for creating a spreadsheet from scratch but this is an output from our present time keeping database per individual, which doesn't count instances for some reason??

ACC_DATE

22/01/2024

23/01/2024

26/06/2024

01/07/2024

02/07/2024

03/07/2024

17/07/2024

18/07/2024

06/08/2024

07/08/2024

08/08/2024

03/12/2024

04/12/2024

05/12/2024

16/12/2024

17/12/2024

18/12/2024

Thank you in advance you wonderful people... apart from Murph that is 

[Senrab_nhoj]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[Redwire]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[libero]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[libero]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

Edited January 14 by libero
Ineptitude

[Senrab_nhoj]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

Edited January 14 by Senrab_nhoj