Peak Seagull
Member
Hi,
In the attached spreadsheet I would like to be able to populate the ‘Next management review due’ (cell C7) with a date that is calculated from the ‘Date of last management review’ (cell C5) and the ‘Management review frequency’ (cell C6).
Is it possible to do this when cell C6 uses a drop down list? or is it better to have a specific number entered into that cell? Also, I would need to ensure that cell C7 is populated with a weekday bot a weekend.
Thanks for your help.
In the attached spreadsheet I would like to be able to populate the ‘Next management review due’ (cell C7) with a date that is calculated from the ‘Date of last management review’ (cell C5) and the ‘Management review frequency’ (cell C6).
Is it possible to do this when cell C6 uses a drop down list? or is it better to have a specific number entered into that cell? Also, I would need to ensure that cell C7 is populated with a weekday bot a weekend.
Thanks for your help.