Create a spreadsheet formula for upcoming contract expiries
Budget: $30 – $250 AUD
Problem: we want to be reminded / flagged when a contract should be renewed / re-tendered.
We want to reminded / flagged six months before the contract expires.
The data point we have is the contract expiry (dd/mm/yyyy).
Solution: if the contract expiry is less than 6 months away, please make column H red. It needs to be done in a google sheet and in excel.
We want to reminded / flagged six months before the contract expires.
The data point we have is the contract expiry (dd/mm/yyyy).
Solution: if the contract expiry is less than 6 months away, please make column H red. It needs to be done in a google sheet and in excel.