Format date with just month and year

[Jay3253]

I need to format a cell so the date automatically changes when the mont
changes. The output I need is 2/06 or 02/06 and when the month change
it should change to 3/06 or 03/06. Thank yo

 

[Doug Kanter]

I need to format a cell so the date automatically changes when the month
changes. The output I need is 2/06 or 02/06 and when the month changes
it should change to 3/06 or 03/06. Thank you

Have you tried clicking (on the menu) Format, Cells, and experimenting with
what you see there?

 

[Niek Otten]

Format>Cells>Number>Custom. In the Type box, enter m/yy

 

[Jay3253]

anyone know?

 

[Mark Lincoln]

In Format Cells, enter either of these as a custom format:

To get 2/06:

m/yy

To get 02/06:

mm/yy

 

[Jay3253]

Thank you very much. I never even thought of that. :

 

[vezerid]

From your post, maybe you should also consider the formula

=TODAY()

Format as mm-yy

HTH
Kostis Vezerides