Thread: Using System Date
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
tiah tiah is offline
external usenet poster
  
Posts: 13
Default Using System Date
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