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 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
Sian, you applied rules to entire column I, thus in formula it shall be =(EDATE($I1,.. instead of =(EDATE($I2,..
Change everywhere in formulas row 2 on row 1, like this
can't see what I'm doing wrong then.
I've copied the formulas and its still not doing it - ive attached a screenshot
can't see what I'm doing wrong then.
I've copied the formulas and its still not doing it - ive attached a screenshot