I need a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I need a formula to do this, I think some function may be used
A1 : Mar-
A2: Mar-
How could A3 be: Mar-1/Mar-
Thanks
 
Hi LDH!

It depends upon whether or not your settings are US or Non-US and whether
you are using dates or text.

If A1 and A2 are dates and you use non-US date settings:
=TEXT(A1,"mmm-yy")&"/"&TEXT(A2,"mmm-yy")

Not quite what you asked for:
Mar-01/Mar-02

If A1 and A2 are dates and you use US date settings:
=TEXT(A1,"mmm-d")&"/"&TEXT(A2,"mmm-d")

If A1 and A2 are text:
=A1&"/"&A2
--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top