Getting system date
 

Hello,

I have this spreadsheet with columns, say *A,B* , *Date* and Grade. On
the last column, I have a date entered.

I do some desicion making, and enter my decision on the grade column
based on a comparisson, of all the columns and the difference bettween
the system date, and the date column eg

If A2 and B5 and date 3 Then
grade="Good"
Else If A2 and B5 and Date<3 Then
Grade="Bad"

Else grade ="Unknown"

The " date <3" implies that the system date is say 26th Sept 2005 and
the entry on the date column is say14th Aug 2004, then date <3 since
the two dates are less than 3 yrs apart.

How do I code that logic?

Thanks


--
oscarooko
------------------------------------------------------------------------
oscarooko's Profile: http://www.excelforum.com/member.php...o&userid=28116
View this thread: http://www.excelforum.com/showthread...hreadid=479422

Getting system date
 

=IF(AND(A12,B15,((TODAY()-C1)/365)3),"GOOD",IF(AND(A12,B15,((TODAY()-C1)/365)<3),"BAD","Unknown"))

This should work for you. Aren't formulas fun.


--
goober
------------------------------------------------------------------------
goober's Profile: http://www.excelforum.com/member.php...o&userid=19838
View this thread: http://www.excelforum.com/showthread...hreadid=479422