Date formatting

[beckys]

Is there a way though the custom number format (or perhaps a different way) that I could type the a single date into a cell (7/31/10, for example), and it would appear in the cell as "07/31/10 - 08/01/10"?

I started with using the custom number format mm/dd/yyyy" - ", but wasn't sure if I could request that the number the space is the original mm/dd/yyyy +1.

Any thoughts?

Thanks for your time!