Wow! That is a massive improvement, and so much more elegant. Thank you so much, Mynda. Definitely plugging that one in now.
I forget that most people's brains don't work exactly like mine does, so I've thrown some data in to help clarify. There definitely will need to be...
Thanks Mynda. Definitely a helpful tip regarding ISNUMBER. I'll keep that in mind for future updates to the file. Also, I realise now that refer...
So, after a couple of week of fiddling, I've managed to get everything working as expected thanks to a handy formula I found online to convert date ra...
So I've worked out that I can use Power Query to list all of the dates in a range (for example, expanding all "rec leave" dates into a single table) -...
My apologies. I did hit the "start upload" button, so I'm not sure if my editing the post before it went live would have affected things.