DrPhil
Outstanding Member
I'm having a brain fart this morning, as I'm sure I've done this before or similar.
I have a spreadsheet with staff start dates. I need a formula to take each staff member and categorise them according to that date.
Either <5, 5-10 or >10
So I need a formula that looks at their start date and tells me at a glance which category they are in. I can easily colour format once the formula applies the result.
Help?
I have a spreadsheet with staff start dates. I need a formula to take each staff member and categorise them according to that date.
Either <5, 5-10 or >10
So I need a formula that looks at their start date and tells me at a glance which category they are in. I can easily colour format once the formula applies the result.
Help?