dates and number

  • Thread starter Thread starter EngelseBoer
  • Start date Start date
E

EngelseBoer

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
 
I'm not sure what you mean by lookup, but you could compare the first 4
characters of A1 with the year of the date in B1 with:

=if(left(a1,4)=text(b1,"yyyy"),"same","different")
 
PERFECT
exactly what i need
thanks Dave

Dave Peterson said:
I'm not sure what you mean by lookup, but you could compare the first 4
characters of A1 with the year of the date in B1 with:

=if(left(a1,4)=text(b1,"yyyy"),"same","different")
Click to expand...
 
Back
Top