Hi Everyone, I am currently working on a spreadsheet for someone at work and require a little help as to how best format and organise the cells to minimise the size when printed and the amount of input cells required to complete by the user. (I think I might need to upload the spreadsheet to anyone who might be willing to help in order for them to get a better understanding).
These are the headers for the cells I have;
‘Date joined Company’, ‘Date of last appraisal’, ‘Next Appraisal Due’ and ‘Status’.
The first appraisal needs to be completed within 6 months of the person first joining the company and then on an annual basis there after. I am struggling with what type of formula I would use to calculate this. I think I might need at least one more column to help with the calculations. (Sorry I’m not sure how to upload a screen shot of the spreadsheet so you guys can get a general idea of what I’m talking about)
I would be most apprieciative if anyone could assist as I’m racking my brains as to the most efficient way of making this work.