Get quarter from date

Summary
Explanation
In this case, the formula first extracts the month as a number between 1-12, then divides this number by 3. The result is then rounded up to the nearest whole number using the ROUNDUP function.
The ROUNDUP function works like the ROUND function, except that ROUNDUP will always round numbers 1-9 upwards to a given number of digits.
Adding a Q
If you want the quarter number to include a "Q" you can concatenate. The formula in D5 is:
The result is the letter "Q" prepended to the quarter number:
Download 100+ Important Excel Functions
Get over 100 Excel Functions you should know in one handy PDF.