Transforming a Date in Quarters of the year & ""-YY"

[Kelli Webb]

Hi, Once again excel has burst my bubble.

I've been managing with this formula just fine, until we started using years 2020, 2030, 2040 etc. if anyone knows how to update my formula, I would be forever grateful.

thanks Kelli

 

[vletm]

Kelli Webb
for cell B2 =IF(ISBLANK($A2),"","Q"&ROUNDUP(MONTH($A2)/3,0)&TEXT($A2,"-yy"))
and copy down

Syntax: =TEXT(Value you want to format, "Format code you want to apply")

 

[Kelli Webb]

Kelli Webb
for cell B2 =IF(ISBLANK($A2),"","Q"&ROUNDUP(MONTH($A2)/3,0)&TEXT($A2,"-yy"))
and copy down

Syntax: =TEXT(Value you want to format, "Format code you want to apply")

I was so close, I was too focused on the end of the formula - thank you so much!

take care,