04-24-2007, 04:13 PM
|
 |
Forum Moderator
|
|
Join Date: 06 Dec 2006
Location: Mississauga, CANADA
MS Office Version:2003 & 2007
Posts: 8,438
|
|
Quote:
|
Originally Posted by kwright90
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.
|
It should be =DATEDIF(TODAY(),B2,"d") where B2 is a date greater than or equal to today's date (i.e. in the future).
__________________
Where there is a will there are many ways. Finding one that works for you is the challenge!
Please read the Forum Rules: Rules
|