Convert Dates into Quarters

How about...

="Q"&ROUNDUP(MONTH(A3)/3,0)

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Your sample file does not help to solve the issue. Mock up an expected result so that we can see what you are attempting. Mind reading is still very challenging for many of us.

Hi Alan, Thanks for looking into it, Let me clarify, I will have only dates in one row. What I want to do is to convert these dates into quarter or months. that is why I sent the file with end/expected result file. I have sent the file again for better understanding. I would appreciate if you could look into this. Thanks

I am sorry, but I do not understand what you want. Hopefully, someone else is better at interpreting your needs. Your explanation while it may be clear to you does not express to me your needs.

Sorry it took so long, but I finally was able to get this to work. Press the button on the Sheet1, but make a copy of the worksheet first so you can validate it is working as you like.

Thank you Jeff, it works perfectly fine.
As you can understand this is part of a Gantt Chart/Schedule, dates will change, and currently in each Cell there is a formula to write the quarter/Year, I will try to write/find a VBA code to automatically write Quarter and Year and then run your code to merge them. Thanks again,

Ok, let us know if you run into a snag. You're welcome.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.