# Column GetYear()

**URL:** <https://community.glideapps.com/t/column-getyear/10134>\
**Category:** Ask for Help\
**Created:** [June 1, 2020, 4:09pm UTC](https://community.glideapps.com/t/column-getyear/10134 "2020-06-01T16:09:18Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Our\_Investments](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/our_investments/32/8247_2.png) [@Our\_Investments](https://community.glideapps.com/u/Our_Investments)\
**Post date:** [June 1, 2020, 4:09pm UTC](https://community.glideapps.com/t/column-getyear/10134/1 "2020-06-01T16:09:18Z")

</div>

Can i create new column that sets the year (only) based on an existing date column ?

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [June 1, 2020, 4:14pm UTC](https://community.glideapps.com/t/column-getyear/10134/2 "2020-06-01T16:14:38Z")

</div>

It’s not possible in Glide, but you can do it inside your spreadsheet.

Let’s say the existing date column is written into column A.

In your column B, write this ARRAYFORMULA into cell B1.

```
={"Year";ARRAYFORMULA(IF(A2:A<>"",YEAR(A2:A),""))}
```

---

<div class="post-metadata">

**Author:** ![Our\_Investments](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/our_investments/32/8247_2.png) [@Our\_Investments](https://community.glideapps.com/u/Our_Investments)\
**Post date:** [June 1, 2020, 4:32pm UTC](https://community.glideapps.com/t/column-getyear/10134/3 "2020-06-01T16:32:52Z")

</div>

Thank You !!!

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [June 1, 2020, 4:40pm UTC](https://community.glideapps.com/t/column-getyear/10134/4 "2020-06-01T16:40:10Z")

</div>

This might be coming soon 😉 …until then, use @ThinhDinh’s solution