In this short video, Jess provides a helpful trick for formatting dates in excel.

The formula you’ll need is as follows:

=DATE(LEFT(A2,4),MID(A2,5,2),RIGHT(A2,2))

IMPORTANT NOTE: This formula is assuming you have the date in the A column. If your date field is in a different column, make sure and tweak your formula. Switch out A for whatever column your stubborn data is in!