How do I convert date/time stamps to quarters (Q1, Q2, etc...)?

lets say your date is in A1  then put ="Q"&ROUNDUP(MONTH(A1)/3,0)

If you have a date field in A2 then try these approaches.  The first just gives the quarter with a "Q", the other includes the year in a slightly different format.  Adjust as needed.

=CONCATENATE("Q",ROUNDUP(MONTH(A2)/3,0))

=CONCATENATE(ROUNDUP(MONTH(A2)/3,0),"Q",YEAR(A2))

---

»bp

Thank you. Both solutions suggested work well when I remove the time zone. Unfortunately the javascript export is in this format and I would like a one step conversion solution, but I'm fine with 2 steps if the first one removes the timezone (EDT).

if you want to remove time from it then first step should be  =TEXT(INT(A1),"MM/DD/YY")  this removes the time

Thank you, but that did not work.

please try this ="Q"&ROUNDUP(MONTH(L5)/3,0)&"-"&YEAR(INT(L5))

This works. Thanks, Bill!

Great.

---

»bp

Thanks, Professor JimJam. This works as well.

you are welcome.

Sorry. Wrong screenshot, Professor JimJam. Here's the correct one.

:)