You are reading a single comment by @NurseHolliday 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.
@NurseHolliday
you could use LEFT and RIGHT in conjunction with DATE to make an actual date field
=DATE(B1,RIGHT(A1,2),LEFT(A1,2))