date into text while keeping the date in its initial format

**Mukapa** · 01-13-2016, 03:13 AM

Greetings,
I have a trouble concerning dates.
I want to put many dates in one single cell but excel is displaying me other numbers which are not dates.

for example, i have the following dates in different cells
Aug 2015
Sept 2015
I want the following result
Aug 2015, Sept 2015
after using the following formula,
=H17&", "&H18
excel is giving me the following result
42217, 42248
I am looking for someone to give me help

**shukla.ankur281190** · 01-13-2016, 03:17 AM

Try

=TEXT(H17,"MMM YYYY")&" , "&TEXT(H18,"MMM YYYY")

Formula:

=TEXT(H17,"MMM YYYY")&" , "&TEXT(H18,"MMM YYYY")

**Kamboj** · 01-13-2016, 03:18 AM

Use

text(a1,"mmm-yyyy") &  text(b1,"mmm-yyyy")

**Mukapa** · 01-13-2016, 03:37 AM

Thank you Shukla, it works

**Mukapa** · 01-13-2016, 03:40 AM

I am sorry, I don't see where I should click to mention that my issue was solved. In fact it was solved!

**FDibbins** · 01-13-2016, 03:43 AM

If this answered your question, please take a moment to mark the thread as "solved"...click the THREAD TOOL towards the top of the screen to find that - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)

**shukla.ankur281190** · 01-13-2016, 03:43 AM

Glad it help you .Go to navigation thread tools ( to of the tread start) and mark it as solved and if you liked any solution add reputation by click * star icon left corner on your screed.

**Mukapa** · 01-13-2016, 04:30 AM

Now after putting the formula above is it possible to scroll it down? so that i can avoid writing it again and again?

**shukla.ankur281190** · 01-13-2016, 04:33 AM

Yes you can

**Mukapa** · 01-13-2016, 04:44 AM

I would like to ask for example, if I have the following months
June 2015
July 2015
August 2015
September 2015
If it is possible to put only the formula for two months and those other months add by them selves.
I tried it but it is not working

**shukla.ankur281190** · 01-13-2016, 04:57 AM

No it is not possible as formula need to tell the range. It can be possible with VBA If you can upload your spreadsheet so we can give you solution according your need.

**Mukapa** · 01-13-2016, 05:07 AM

I am a beginner to the forum. What is VBA please?

**shukla.ankur281190** · 01-13-2016, 05:12 AM

It will be better if you can upload the spreadsheet for uploading Go to Advance and click on attachment link.

What is VBA?
Ans->Excel VBA (Visual Basic for Applications) is the name of the programming language of Excel. 1 Create a Macro: With Excel VBA you can automate tasks in Excel by writing so called macros. In this chapter, learn how to create a simple macro.

**Mukapa** · 01-13-2016, 05:36 AM

I don't see advance, can you indicate it for me please?

**Mukapa** · 01-13-2016, 05:40 AM

i have uploaded an excel document. there are a number of months I want to use the formula you have given me on few months and then scroll down to other months
thank you

**Mukapa** · 01-13-2016, 05:25 AM

I don't understand the second paragraph, I am not an IT

**Mukapa** · 01-13-2016, 07:49 AM

i have uploaded an excel document. there are a number of months I want to use the formula you have given me on few months and then scroll down to other months
thank you

**shukla.ankur281190** · 01-13-2016, 08:23 AM

Try

D2=IFERROR(LOOKUP(2,1/($A$1:A1=A2),TEXT($D$1:D1,"MMM-YY"))&","&TEXT(B2,"MMM-YY"),TEXT(B2,"MMM-YY")) Drag Down

Formula:

=IFERROR(LOOKUP(2,1/($A$1:A1=A2),TEXT($D$1:D1,"MMM-YY"))&","&TEXT(B2,"MMM-YY"),TEXT(B2,"MMM-YY"))

B23=LOOKUP(2,1/($A$2:$A$20=A23),$D$2:$D$20) and drag down

Formula:

=LOOKUP(2,1/($A$2:$A$20=A23),$D$2:$D$20)

Check the attached file.

**Mukapa** · 01-13-2016, 09:07 AM

I prefer to apply the previous formula,
Thank you

date into text while keeping the date in its initial format

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

date into text while keeping the date in its initial format

Re: date into text while keeping the date in its initial format

Re: date into text while keeping the date in its initial format

Re: date into text while keeping the date in its initial format

Re: date into text while keeping the date in its initial format

Re: date into text while keeping the date in its initial format

Re: date into text while keeping the date in its initial format

Re: date into text while keeping the date in its initial format

Re: date into text while keeping the date in its initial format

Re: date into text while keeping the date in its initial format

Re: date into text while keeping the date in its initial format

Re: date into text while keeping the date in its initial format

Re: date into text while keeping the date in its initial format

Re: date into text while keeping the date in its initial format

Re: date into text while keeping the date in its initial format

Re: date into text while keeping the date in its initial format

Re: date into text while keeping the date in its initial format

Re: date into text while keeping the date in its initial format

Re: date into text while keeping the date in its initial format

Thread Information

Users Browsing this Thread

Similar Threads

Combining cells, keeping date format.

Data Analysis: Compare initial date with final date by looking up the latest revision

[SOLVED] Data Validation: using date in as initial date in range

Concatenate text, date and time keeping format

Keeping Date Format in String

Keeping Date in current format when including in text string

Convert cell category from Date to Text, keeping mm/dd/yyyy format

Bookmarks

Bookmarks

Posting Permissions