Split a date into numbers

Premium

In B2, use SPLIT to split the date text in A2 at the dashes into year, month and day.

B2
ABCDEF
1Date as text Year Month Day
22024-03-15
3
4
5
6
7
8

Premium lesson

Unlock SPLIT and JOIN and every other lesson

This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.

Next with premium:REGEX functionsIF

Your first month for $9.50 $19

50% off your first month when you join today.

Get your first month for $9.50

Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.

Already premium? Sign in
Need help?