Get Year from Date

Please help me write this formula

cell A2 has date

=IFS(ISNUMBER(A2),"Q1 ",ISNUMBER(A2),YEAR(A2))

Result I need is Q1 2018

Thank you!

i don't understand the result expected, is it to get the quarter (Q1، Q2, Q3, Q4) including year

Try this;

Formula:

Please Login or Register  to view this content.

this works, thank you so much

Great work