Change date to quarter of a year

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have dates in one column and I would like to put in the next column the
quarter of the year. Example if in cell "A1" I enter date "30 Jan 2005", I
would like to show "1Q2005" or similarin Cell "B1".
Can you help?
 
You must log in or register to reply here.

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

Similar Threads

Quarterly inputs 2
Calculating quarters of a year. 4
Quarters 1
Calculation of Quarter 16
Return the current Yearly Quarter based on date 2
Lumping dates into quarters by year 3
Excel Vba to change displayed year automatically. 14
I want quarters not months 5

Back
Top