Format date with just month and year

J

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
 
D

Doug Kanter

Jay3253 said:
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
Click to expand...

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

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
 
V

vezerid

From your post, maybe you should also consider the formula

=TODAY()

Format as mm-yy

HTH
Kostis Vezerides
 
Top