Sawdeeka01
New Member
- Joined
- Mar 31, 2020
- Messages
- 37
- Office Version
- 365
Hi, I am really hoping you could assist a novice please.
I have developed a spreadsheet to track exemptions, and auto populate a unique reference number for departmental use. What I need to do is come up with a formula to achieve this, as well as build in a couple of variances.
When completing the spreadsheet, the Exemption End Date (column I (locked cell)) will highlight when the date is within a 4 week period of the exemption ending, this is a sum of Date Exemption Received + Exemption Duration * 7 (F2+H2*7)
When the Committee Approval (column K) contains 'Yes' the Approval Reference Number (column L (locked cell)) will auto populate with the unique reference number using information from A2, C2, E2, I2, no matter what I do I cannot get this to run correctly and really need your expertise here please!
I also need to add variances into column L so that if a date is not available in column I, the unique reference number replaces the blank with 'Pregnancy'. Is this something that is achievable? I really hope I have explained that ok!
I have developed a spreadsheet to track exemptions, and auto populate a unique reference number for departmental use. What I need to do is come up with a formula to achieve this, as well as build in a couple of variances.
When completing the spreadsheet, the Exemption End Date (column I (locked cell)) will highlight when the date is within a 4 week period of the exemption ending, this is a sum of Date Exemption Received + Exemption Duration * 7 (F2+H2*7)
When the Committee Approval (column K) contains 'Yes' the Approval Reference Number (column L (locked cell)) will auto populate with the unique reference number using information from A2, C2, E2, I2, no matter what I do I cannot get this to run correctly and really need your expertise here please!
I also need to add variances into column L so that if a date is not available in column I, the unique reference number replaces the blank with 'Pregnancy'. Is this something that is achievable? I really hope I have explained that ok!