Monthname

[#1]

usually monthname will get you 'MMM YYYY', how can it be done if we want the format to be MMM-YY?

eg;

monthname ( '2001-10-19' ) returns 'Oct 2001' - by default

how to get

'Oct-01' instead of 'Oct 2001'.

[jagannalla]

Try this:

=Date(monthname ( '2001-10-19' ),'MMM YY')

Otherwise you can try

=Date('2001-10-19' ,'MMM YY')

[pgalvezt]

Hi, Go to properties - Tab Number (Format) - Date (Yo can change the format date in this option)

Hope Help you!

[MayilVahanan]

HI

Try like this

=Date(monthname ( '2001-10-19' ),'MMM YYYY')

returns oct 2001

hope it helps