Extracting date information

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

I have visited different websites and have found how to
extract the week, month and quarter from a certain cell,
but it is not in the way that I need it. This is what I
have found.
Week Month Quarter
08/22/2003 34 8 3

Is there a way that I can write a formula or vba to get
the following results?

Week Month Quarter
08/22/2003 34-2003 August Q3-2003

TIA
 
Back
Top