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...
can't see what I'm doing wrong then.
I've copied the formulas and its still not doing it - ive attached a screenshot
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