Days until Expiry
I have made a field to work out the days until the expiry of a certificate, the calculation also turns the number of days to an amber colour if there are less than 28 days but more than 0 days to expiry.
At the moment this calculation works fine unless there are between 3-9 days to expiry in which case it does not change the colour of the text.
Any input would be appreciated.
please see the calculation below: