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:

and the results are these

This entry was posted in CalculatedColumn. Bookmark the permalink.