Thanks alot for the info.

I believe I need to calculate in the contract length somewhere in this formula somehow. I do have a column that states the length. Most range from 3-5 years.


It is giving me an error #NUM! in the formula cell (=DATEDIF,TODAY(),B2,"d"). I assume this is because it needs a contract length in order to determin the time remaining.