Custom date range format

[DashboardNovice]

In cell D9, I have a custom date format:

mm/dd/yyyy - mm/dd/yyyy

The result I am trying to get would look like cell F9.

What is wrong with my custom format?

 

[vletm]

DashboardNovice​

Your D9 is text.
You could get Your output eg this way...

 

[DashboardNovice]

DashboardNovice​

Your D9 is text.
You could get Your output eg this way...

Yeah, I know about the TEXT( ), but in this case, I need the custom formatting to apply to the cell where the user enters the date range.

 

[vletm]

... then You have to change Your master idea.
Now, Your user enters string.
Your user should able to fill those dates in separate cells.
After that, those would be useful for further use too.