View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
EngelseBoer EngelseBoer is offline
external usenet poster
 
Posts: 67
Default dates and number

hi again

is it possible to look-up part numbers ? and compare dates

i.e. in the below..
can the year "2003" be compared to the 1st 4 ditgets of the Reg number
and return False if not

Reg. No. D.O.B
2003101871005 22/12/2003


regards
Malcolm