date formula issues
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
---
Per
"Annie" skrev i meddelelsen
...
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?
--
Thanks, Annie
|