You are reading a single comment by @Chalfie and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
duncs
@Chalfie
=DATEVALUE(REPLACE(REPLACE(A1,1,1,""),3,1,"/"))
edit:
=DATEVALUE(REPLACE(REPLACE(A1,1,1,""),2,1,"/"))
or even
=DATEVALUE(REPLACE(A1,3,1,"/"))