Thread: Using System Date
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default 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



Reply With QuoteReply With Quote