Re: Quick Excel Question
Ok I've got one... Anyone use DATEVALUE
I have 2 columns with dates; THe first column is the start date on a rental contract and the second column is today's date. edit: (or the closing date of the contract)
I want warnings when the contract is 70, 80, and 89 days old. I need a third column to have an "if" formula that gives me some sort of text as a warning.
I think I need to use a datevalue for the start date argued against a datevalue for todays date.
Any help would be much appreciated.
And then there's this asshole...
Last edited by phobiaphobe; 07-15-2005 at 12:15 PM.