Using System Date
 

Hello,

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

I do some desicion making, and enter my decision on the grade colum
based on a comparisson, of all the columns and the difference bettwee
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 an
the entry on the date column is say14th Aug 2004, then date <3 sinc
the two dates are less than 3 yrs apart.

How do I code that logic?

Thank

--
oscarook
-----------------------------------------------------------------------
oscarooko's Profile: http://www.excelforum.com/member.php...fo&userid=2811
View this thread: http://www.excelforum.com/showthread.php?threadid=47943

Using System Date
 

NbYears=year(SystemDate) - year(DateInColumn)

it will give you the number of years and then you can see if < or 3

Using System Date
 

I am not sure it is a simple as that:

? Year(DateValue("Jan 1, 2005")) - year(dateValue("Dec 31, 2004"))
1

But I guess it depends on how the OP defines the difference.

--
Regards,
Tom Ogilvy


"tiah" wrote in message
ups.com...
NbYears=year(SystemDate) - year(DateInColumn)

it will give you the number of years and then you can see if < or 3

Using System Date
 

ok, i see ! :)

so then make the difference directly :

? round ( ( datevalue("2005-01-01") - DateValue("2004-12-31") )/365.25
,0)


it gives you a number of days, then /365.25 gives you into years
the round makes it no decimals

does it makes sense now ? :)