Thread: date format and the RIGHT function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SteveG
 
Posts: n/a
Default date format and the RIGHT function

Rich,

Your formula is returning the last two digits of the Excel serial
number for the date. July = 38534, Aug = 38565, Sept = 38596. Use
this instead.

=RIGHT(YEAR(C1),2)

HTH,

Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=494553

Reply With QuoteReply With Quote