Creating Custom Date Function in Excel -

i trying code date function in excel using month , last 2 digits of year. example have numbers 1-12 in column. want code them follows. 1 jan-15, 2 feb-15,..june-15. 7 july-14, 8 aug-14. whenever try type in codes them respective month, day , year 2015. know have create custom format date function, how go doing in case. have seen things, many of times unclear. me out.

this link can out.

create custom date format

if want use format isn’t in type box, can create own. easiest way start format close want.

select cells want format.

press ctrl+1.

in format cells box, click number tab.

in category list, click date, , under type, pick date format close format want.

go category list, , pick custom. under type, you’ll see format code date format picked in step 4. built-in date format can’t changed, don’t worry messing up. changes make apply custom format you’re creating.

in type box, make changes want using code table below.

according table there , description suppose should use custom format like:

mmm-yy