text to date

swabeeh 

Assuming your base dates are in form of three letters and 2 numbers, serparated by "-" (e.g. Jun 06 - Jun 21, 24), you can use:

=TEXTJOIN(", ",,LEFT(E4,6),RIGHT(E4,2))

In your start date cell.

And,

=RIGHT(E4,LEN(E4)-FIND("-",E4)-1)

In your end date cell.

That would achieve your desired goal to transform the string into two separated cells. You would then apply the corresponding formatting to look as desired.