Convert ddmmyy to Qtr yy

[dessim]

Afternoon Ppl,

need some help here, how do i convert eg 25122019 (ddmmyyyy) or 251219 (ddmmyy) to show its Qtr4 19 ?

Any solution to this ?

Much thanks.

 

[dessim]

I see it now. Cool. Digging around in the docs i saw that you can use escape characters, didn't know that, so here's another way.

Function QUARTER(d As Date) As String
QUARTER = Format(d, "\Qtrq yy")
End Function

Many thanks to all, I finally managed to get it done.
Thanks once again.

Being a excel novice, I gues I would "appear with more questions"
Pls guide me along :P
Hv a gd day!