Hi All,
So, the company who I work for do this really complicated thing whereby if you're being made redundant but you go on a secondment, they pause your notice period whilst you're on the secondment and then reinstate the remainder of your notice period, so it runs concurrently until the end of your secondment (making the end of the secondment your last day with the company).
Example:
Date of my formal notice letter telling me I have four month's notice to work - 01/05/2020
Date my secondment begins (and notice is paused) - 03/06/2020
Notice I've already worked - 1 month and 3 days
Notice remaining - 2 months and 27 days (of my 4-month notice period)
Expected end of secondment - 30/11/2020
Notice period reinstatement date (30/11/2020 minus 2 months and 27 days) = 03/09/2020
In simple terms, work a portion of notice, pause notice, reinstate the remainder to run up until secondment end date.
Question is, how can this be calculated on excel to make my colleague's lives easier? I've gotten all the way to "notice remaining" on the attached but I'm completely stuck. Hoping for someone who is an excel expert but also understands HR practices with UK notice periods to see if they can solve this.
P.S, this will be a general calculator, so it will need to calculate from the "employee notice (months)" cell as this will change depending upon the employee's grade etc.
Regards
Chris
Bookmarks