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...
Thank you so much. I've literally just managed to sort the length of service bit out. and will definitely have a look at the second part now.
I'm in the UK so UK based is perfect for me! I think the problem was that i'd put the dates in in 01.01.13 instead of 01/01/13 which was causing a lot of the problems.
Thanks again for a quick response
No problem - you need to make sure your cells are formatted as Short Date too.. otherwise calculations return an integer - good luck,
Andrew