Forum Discussion
Excel Formula help needed please
Hello, I am creating a spreadsheet showing date of joining and when annual reviews are due. I've searched the web but still can't quite work out how to use the correct formulas; I have two questio...
Thanks both, I'm still struggling for the second part, I don't know why but its just not working for me - i'm now not getting any colours at all - I'm clearly not cut out for Excel and trying to make things easier for myself!!
Hi Sian,
Please check the file attached
Thanks but it's still not working, the rules are only showing on one of the dates for some reason which is in January next year- don't worry I'll just have to not bother using it. Just wanted an easy visual way of seeing who was due their annual review quickly :(
Sian, in file I submitted previous time it works
if I understood your logic correctly
can't see what I'm doing wrong then.
I've copied the formulas and its still not doing it - ive attached a screenshot