Date Format

E

Elton Law

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?
 
D

David Biddulph

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

Jarek Kujawa

sorry

with dates in A1 and B1 the formula should read:

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


HIH
 
M

Ms-Exl-Learner

Use Text function.

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

Remember to Click Yes, if this post helps!
 
E

Elton Law

Thanks so much.
It works !!!

Ms-Exl-Learner said:
Use Text function.

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

Remember to Click Yes, if this post helps!
Click to expand...
 
R

Rick Rothstein

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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate elapsed time excluding specific timeframe 10
Conditional Sum - Moving Average 6
Look for Max and second Max 0
Transposing Array 4
How to determine the value? 2
Dynamic chart 1
When building a chart Dates are been included that are not in thedate range 2
Text lookup array and match specific data 3

Top