Calculate Q/YY from a date column

…this post was published on 2015 December 1.

Starting from this post, let’s start
I create a new list, with only 2 new fields
First one with the name [Date] as Date type column and a new calculated column, name [Q/YY]


Before I start the calculation, i fill the list with a date value for each month as bellow

The formula I’ve used is this one:
=CONCATENATE(1+INT(MONTH(Date)/4),”/”,TEXT(Date,”yy”))

and the results are these

This entry was posted in CalculatedColumn. Bookmark the permalink.