date formula issues

  • Thread starter Thread starter Annie
  • Start date Start date
A

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?
 
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
 
Back
Top