ExcelBanter - Date Format

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Date Format (https://www.excelbanter.com/excel-worksheet-functions/250309-date-format.html)

Elton Law[_2_]

Date Format

Dear Expert,
Maybe for you,it's easy ... but I really cannot make it.
Cell A1 is Date 21-Feb-1994
Cell B1 is Date 23-Mar-1994
I used A1&"/"&A2. I give a chance of numbers.
I just want to display 21-Feb-1994/23-Mar-1994.
Can you advise how to?

David Biddulph[_2_]

Date Format

=TEXT(A1,"dd-mmm-yyyy")&"/"&TEXT(A2,"dd-mmm-yyyy")
.... or B1 if you want that instead of A2 ...
--
David Biddulph

"Elton Law" wrote in message
...
Dear Expert,
Maybe for you,it's easy ... but I really cannot make it.
Cell A1 is Date 21-Feb-1994
Cell B1 is Date 23-Mar-1994
I used A1&"/"&A2. I give a chance of numbers.
I just want to display 21-Feb-1994/23-Mar-1994.
Can you advise how to?

Jarek Kujawa[_2_]

Date Format

=TEXT(A1,"dd-mmm-yyyy") & "/" & TEXT(A2,"dd-mmm-yyyy")

HIH

On 7 Gru, 09:19, Elton Law wrote:
Dear Expert,
Maybe for you,it's easy ... but I really cannot make it.
Cell A1 is Date 21-Feb-1994
Cell B1 is Date 23-Mar-1994
I used A1&"/"&A2. I give a chance of numbers.
I just want to display 21-Feb-1994/23-Mar-1994.
Can you advise how to?

Jarek Kujawa[_2_]

Date Format

sorry

with dates in A1 and B1 the formula should read:

=TEXT(A1,"dd-mmm-yyyy") & "/" & TEXT(B1,"dd-mmm-yyyy")

HIH

On 7 Gru, 09:19, Elton Law wrote:
Dear Expert,
Maybe for you,it's easy ... but I really cannot make it.
Cell A1 is Date 21-Feb-1994
Cell B1 is Date 23-Mar-1994
I used A1&"/"&A2. I give a chance of numbers.
I just want to display 21-Feb-1994/23-Mar-1994.
Can you advise how to?

Ms-Exl-Learner

Date Format

Use Text function.

=TEXT(A1,"DD-MMM-YYYY")&"/"&TEXT(A2,"DD-MMM-YYYY")

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------

"Elton Law" wrote:

Dear Expert,
Maybe for you,it's easy ... but I really cannot make it.
Cell A1 is Date 21-Feb-1994
Cell B1 is Date 23-Mar-1994
I used A1&"/"&A2. I give a chance of numbers.
I just want to display 21-Feb-1994/23-Mar-1994.
Can you advise how to?

Elton Law[_2_]

Date Format

Thanks so much.
It works !!!

"Ms-Exl-Learner" wrote:

Use Text function.

=TEXT(A1,"DD-MMM-YYYY")&"/"&TEXT(A2,"DD-MMM-YYYY")

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------

"Elton Law" wrote:

Dear Expert,
Maybe for you,it's easy ... but I really cannot make it.
Cell A1 is Date 21-Feb-1994
Cell B1 is Date 23-Mar-1994
I used A1&"/"&A2. I give a chance of numbers.
I just want to display 21-Feb-1994/23-Mar-1994.
Can you advise how to?

Ms-Exl-Learner

Date Format

You're welcome and thanks for feeding back€¦

--------------------
(Ms-Exl-Learner)
--------------------

"Elton Law" wrote:

Thanks so much.
It works !!!

"Ms-Exl-Learner" wrote:

Use Text function.

=TEXT(A1,"DD-MMM-YYYY")&"/"&TEXT(A2,"DD-MMM-YYYY")

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------

"Elton Law" wrote:

Dear Expert,
Maybe for you,it's easy ... but I really cannot make it.
Cell A1 is Date 21-Feb-1994
Cell B1 is Date 23-Mar-1994
I used A1&"/"&A2. I give a chance of numbers.
I just want to display 21-Feb-1994/23-Mar-1994.
Can you advise how to?

Rick Rothstein

Date Format

You can save one concatenation operation by moving the slash into one of the
format patterns, for example...

=TEXT(A1,"DD-MMM-YYYY/")&TEXT(A2,"DD-MMM-YYYY")

--
Rick (MVP - Excel)

"Elton Law" wrote in message
...
Dear Expert,
Maybe for you,it's easy ... but I really cannot make it.
Cell A1 is Date 21-Feb-1994
Cell B1 is Date 23-Mar-1994
I used A1&"/"&A2. I give a chance of numbers.
I just want to display 21-Feb-1994/23-Mar-1994.
Can you advise how to?

All times are GMT +1. The time now is 10:56 AM.