View Single Post
  #1   Report Post  
Jim
 
Posts: n/a
Default Converting a date in Excel 2002 to a Year/Quarter format

Is there a formula or function that I can use in Excel 2002 to convert a date
to a year/quarter format. For instance if the date said 2/35/2005, I would
like to represent that as 2005Q1 or Q12005, something like that. If someone
has an idea, please share it. Thanks.