# Year Function

**URL:** <https://community.velixo.com/t/year-function/69>\
**Category:** General\
**Created:** [August 2, 2024, 6:52pm UTC](https://community.velixo.com/t/year-function/69 "2024-08-02T18:52:07Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Daryl](https://community.velixo.com/letter_avatar_proxy/v4/letter/d/87869e/32.png) [@Daryl](https://community.velixo.com/u/Daryl)\
**Post date:** [August 2, 2024, 6:52pm UTC](https://community.velixo.com/t/year-function/69/1 "2024-08-02T18:52:07Z")

</div>

Hi,

This is a request to add a function that adds up all the months of a year to provide a total for that year. Right now I have to pull 12 months then create a formula that adds up the months. It would be a huge help to have a function that does this. Thanks!

---

<div class="post-metadata">

**Author:** ![Gabriel](https://community.velixo.com/user_avatar/community.velixo.com/gabriel/32/7_2.png) [@Gabriel](https://community.velixo.com/u/Gabriel)\
**Post date:** [August 2, 2024, 7:43pm UTC](https://community.velixo.com/t/year-function/69/2 "2024-08-02T19:43:34Z")

</div>

Hi Daryl,

Are you using the =ACCOUNTTURNOVER() function? This function has both a From and a To period argument, allowing you to get the total turnover for a year. For example:

```auto
=ACCOUNTTURNOVER("Demo", "ACTUAL",, "40000", , , "01-2019", "06-2019")

```

…will give you the total for the first 6 months of the year for account 40000.

Is this what you’Re trying to achieve?

---

<div class="post-metadata">

**Author:** ![Daryl](https://community.velixo.com/letter_avatar_proxy/v4/letter/d/87869e/32.png) [@Daryl](https://community.velixo.com/u/Daryl)\
**Post date:** [August 21, 2024, 11:40pm UTC](https://community.velixo.com/t/year-function/69/3 "2024-08-21T23:40:36Z")

</div>

This is perfect! Thanks so much!!!
