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