date formula issues

[Annie]

Can anyone help me with the following issue. In cel1 A1 I have a date
4/3/2008. In cell B1 I want to show 4/3/2008 as Apr08 or Apr2008. I am
using =month (A1)&Year(A1) and the result is 42008. Can anyone help me
revise the formula so that it will show the month as text and preferrably a 2
yr date Apr08?

 

[Per Jessen]

Hi Annie

Format B1 as Date to display the result as a date.

Or

let the formula in B1 be =A1
Select B1 and goto Format > Format Cells > Number > Custom > In the Type:
field enter mmmyy > OK

Hopes this helps

 

[T. Valko]

Try this:

=TEXT(A1,"mmmyy")