Hi! I'm very new to formulas on excel and learning as I go and by googling a lot!
I have a spreadsheet full of staff names and training completion dates. I have hidden staff who are on long term sick or maternity leave and want to create a formula to count how many staff are currently in date and how many are out of date so that I can then ultimately work out the percentage of the full team who are in date. Can anyone help me with this?
I used =SUBTOTAL to calculate how many staff are visible after hiding those on LTS and maternity but I don't know how to proceed after this
I have a spreadsheet full of staff names and training completion dates. I have hidden staff who are on long term sick or maternity leave and want to create a formula to count how many staff are currently in date and how many are out of date so that I can then ultimately work out the percentage of the full team who are in date. Can anyone help me with this?
I used =SUBTOTAL to calculate how many staff are visible after hiding those on LTS and maternity but I don't know how to proceed after this