I’m struggling with formula to solve the following: My client has a 5 year project. Their project year starts in October each year and is divided into quarters. I’m struggling to turn a date into a Y1Q2, Y3Q4 output so they can see what quarter each ...

I’m trying to count the number of female attendees in a training session - I’ve managed to get them into a text string (eg: ,Female,Female, ) but can’t count the number of times the word ‘Female’ appears. I just can’t work out the formula to give me ...