Thread: Date Format
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elton Law[_2_] Elton Law[_2_] is offline
external usenet poster
 
Posts: 173
Default 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?