Two dates in one cell

%3CLINGO-SUB%20id%3D%22lingo-sub-2177203%22%20slang%3D%22en-US%22%3ETwo%20dates%20in%20one%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2177203%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20trouble%20finding%20out%20how%20to%20do%20this.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20fit%20in%20two%20dates%20in%20one%20cell%20without%20messing%20up%20the%20format%3C%2FP%3E%3CP%3Ethe%20format%20I%20have%20in%20mind%20is%20d-mmm-yy%3C%2FP%3E%3CP%3Ehowever%20everytime%20I%20input%20two%20dates%20in%20one%20cell%3C%2FP%3E%3CP%3Ethe%20format%20changes%20to%20the%20other%20one%3C%2FP%3E%3CP%3EHow%20do%20I%20maintain%20or%20fix%20the%20format%20so%20that%20both%20dates%20remain%20as%20such%20in%20one%20cell%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%20of%20what%20I%20want%20to%20dates%20in%20one%20cell%20looks%20like%3A%3C%2FP%3E%3CP%3E01-Jan-21%20-%2002-Jan-21%3C%2FP%3E%3CP%3EPlease%20help%20me.%20I%20am%20helpless!%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2177203%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2177245%22%20slang%3D%22en-US%22%3ERe%3A%20Two%20dates%20in%20one%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2177245%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F983160%22%20target%3D%22_blank%22%3E%40Dyla_1806%3C%2FA%3E%26nbsp%3BYou%20mean%20like%20this%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-03-02%20at%2011.36.32.png%22%20style%3D%22width%3A%20348px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F259642i58150BFE02B476CD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-03-02%20at%2011.36.32.png%22%20alt%3D%22Screenshot%202021-03-02%20at%2011.36.32.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EWhen%20you%20enter%2001-jan-21%2C%20Excel%20recognises%20it%20as%20a%20data.%20It%20gets%20%22translated%22%20to%2001%2F01%2F2021%20but%20its%20displayed%20as%20you%20typed%20it.%20If%20you%20than%20add%20%22%20-%2002-jan-21%22%20to%20that%2C%20it%20become%20a%20text%20like%20in%20the%20picture%20above.%20So%2C%20just%20type%20the%20whole%20text%20string%20in%20one%20go%20%2201-jan-21%20-%2002-jan-21%22.%20Then%20it%20will%20show%20as%20desired.%20But%2C%20be%20aware%20that%20you%20are%20no%20longer%20working%20with%20real%20dates.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi all,

 

I have trouble finding out how to do this. 

 

I want to fit in two dates in one cell without messing up the format

the format I have in mind is d-mmm-yy

however everytime I input two dates in one cell

the format changes to the other one

How do I maintain or fix the format so that both dates remain as such in one cell

 

Example of what I want to dates in one cell looks like:

01-Jan-21 - 02-Jan-21

Please help me. I am helpless!

Thank you in advance 

3 Replies

@Dyla_1806 You mean like this?

Screenshot 2021-03-02 at 11.36.32.png

When you enter 01-jan-21, Excel recognises it as a data. It gets "translated" to 01/01/2021 but its displayed as you typed it. If you than add " - 02-jan-21" to that, it become a text like in the picture above. So, just type the whole text string in one go "01-jan-21 - 02-jan-21". Then it will show as desired. But, be aware that you are no longer working with real dates.

Yes except when I input it as what you told me to it came out as
01/01/2021-02/01/2021

@Dyla_1806 Can't replicate that on my machine. When I enter the string as in my previous post, I get this:

Screenshot 2021-03-02 at 12.10.38.png