View Single Post
  #5   Report Post  
Max
 
Posts: n/a
Default

Thanks, Frank ! You're right.
Must have done something wrong first,
that's why it went the long route <g
--
Rgds
Max
xl 97
--
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
---
"Frank Kabel" wrote
Hi Max
no need for first getting the Year, month, day
=TEXT(A2,"mm/dd")

for example would be sufficient :-))


--
Regards
Frank Kabel
Frankfurt, Germany