Get Current Period

[#1]

Hi All,

There are function calculating current Year,Month,Week but is there anyway i can get the current period?

Thanks in advance!

[pover]

What do you mean by period? Fiscal period? Quarter? Semester?

Regards.

[#3]

Here is the example of my data in period,

199001,

199002,

199003,

199004

It is something like quarter.

[pover · Accepted solution]

Would this work?

=year(today())&'0'&ceil(month(today())/3)

[#5]

Ya, it works perfectly! Thanks!