How do I get Current Year And Current Quarter

[Mathman]

I need to get current year and quarter to update automatically then have previous quarters also displayed. And would like it to be display as shown below. Any suggestion as to how I can do this?


[TABLE="width: 55"]
<tbody>[TR]
[TD="width: 55, bgcolor: transparent, align: right"]2018.1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2017.4[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2017.3[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2017.2[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2017.1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2016.4[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2016.3[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2016.2[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2016.1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2015.4[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2015.3[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2015.2[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2015.1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2014.4[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2014.3[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2014.2[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2014.1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2013.4[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2013.3[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2013.2[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2013.1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2012.4[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2012.3[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2012.2[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2012.1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2011.4[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2011.3[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2011.2[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2011.1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2010.4[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2010.3[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2010.2[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2010.1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2009.4[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2009.3[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2009.2[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2009.1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2008.4[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2008.3[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2008.2[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2008.1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2007.4[/TD]
[/TR]
</tbody>[/TABLE]
​

 

[Joe4]

Use this formula in row 1, and copy down:

=YEAR(EDATE(TODAY(),(ROW()-[COLOR=#ff0000]1[/COLOR])*-3)) & "." & ROUNDUP(MONTH(EDATE(TODAY(),(ROW()-[COLOR=#ff0000]1[/COLOR])*-3))/3,0)

If you are starting in any row other than row 1, change the number in red in the formula above to the row you are putting the first (current date) formula in.

 

[frank_AL]

Assuming a data in cell A1 this formula worked for me.
=CONCATENATE(YEAR(A1)&"."& ROUNDUP(MONTH(A1)/3,0))

 

[wideboydixon]

Book1
	A
1	2018.1
2	2017.4
3	2017.3
4	2017.2
5	2017.1
6	2016.4
7	2016.3
8	2016.2
9	2016.1
10	2015.4
11	2015.3
12	2015.2
13	2015.1
14	2014.4
15	2014.3
16	2014.2
17	2014.1
18	2013.4
19	2013.3
20	2013.2
21	2013.1
22	2012.4
23	2012.3
24	2012.2
25	2012.1
26	2011.4
27	2011.3
28	2011.2
29	2011.1
30	2010.4
31	2010.3
32	2010.2
33	2010.1
34	2009.4
35	2009.3
36	2009.2
37	2009.1
38	2008.4
39	2008.3
40	2008.2
41	2008.1
42	2007.4
Sheet1

Cell Formulas
Range	Formula
A1	=YEAR(EOMONTH(TODAY(),3-ROW()*3))&"."&INT((MONTH(EOMONTH(TODAY(),3-ROW()*3))-1)/3)+1

WBD