Format date with just month and year
 

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


--
Jay3253
------------------------------------------------------------------------
Jay3253's Profile: http://www.excelforum.com/member.php...fo&userid=5955
View this thread: http://www.excelforum.com/showthread...hreadid=507745

Format date with just month and year
 

"Jay3253" wrote in
message ...

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?

Format date with just month and year
 

FormatCellsNumberCustom. In the Type box, enter m/yy

--
Kind regards,

Niek Otten

"Jay3253" wrote in
message ...

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


--
Jay3253
------------------------------------------------------------------------
Jay3253's Profile:
http://www.excelforum.com/member.php...fo&userid=5955
View this thread: http://www.excelforum.com/showthread...hreadid=507745

Format date with just month and year
 

anyone know?


--
Jay3253
------------------------------------------------------------------------
Jay3253's Profile: http://www.excelforum.com/member.php...fo&userid=5955
View this thread: http://www.excelforum.com/showthread...hreadid=507745

Format date with just month and year
 

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

To get 2/06:

m/yy

To get 02/06:

mm/yy

Format date with just month and year
 

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


--
Jay3253
------------------------------------------------------------------------
Jay3253's Profile: http://www.excelforum.com/member.php...fo&userid=5955
View this thread: http://www.excelforum.com/showthread...hreadid=507745

Format date with just month and year
 

From your post, maybe you should also consider the formula

=TODAY()

Format as mm-yy

HTH
Kostis Vezerides