Thread: Format date with just month and year
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jay3253
 
Posts: n/a
Default 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

Reply With QuoteReply With Quote