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
 
forgot the last one
="Q"&INT((MONTH(F13)-1)/3)+1&"-"&YEAR(F13)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top