# Financial Year based on my date column?

**URL:** <https://forums.knack.com/t/financial-year-based-on-my-date-column/15474>\
**Category:** Get Answers\
**Created:** [January 6, 2024, 8:03am UTC](https://forums.knack.com/t/financial-year-based-on-my-date-column/15474 "2024-01-06T08:03:29Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![RCB](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/rcb/32/2371_2.png) [@RCB](https://forums.knack.com/u/RCB)\
**Post date:** [January 6, 2024, 8:03am UTC](https://forums.knack.com/t/financial-year-based-on-my-date-column/15474/1 "2024-01-06T08:03:29Z")

</div>

Hello everyone, hope you had a fantastic new year!

How might I create a new column based on my date column, converting it into a financial year that commences in July ie. July 2023 → FY24, July 2024 → FY25, etc.

---

<div class="post-metadata">

**Author:** ![CarlHolmes](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/carlholmes/32/2814_2.png) [@CarlHolmes](https://forums.knack.com/u/CarlHolmes)\
**Post date:** [January 6, 2024, 2:40pm UTC](https://forums.knack.com/t/financial-year-based-on-my-date-column/15474/2 "2024-01-06T14:40:22Z")

</div>

I hope I’ve understood the requirement correctly. There may be an easier way to do it with only using one field but I’ve had to use an equation and then a text forumula 🤷‍♂️

---

<div class="post-metadata">

**Author:** ![CarlHolmes](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/carlholmes/32/2814_2.png) [@CarlHolmes](https://forums.knack.com/u/CarlHolmes)\
**Post date:** [January 6, 2024, 4:33pm UTC](https://forums.knack.com/t/financial-year-based-on-my-date-column/15474/3 "2024-01-06T16:33:50Z")

</div>

After discussing this with my (far more intelligent) wife, she pointed out my error. Hopefully, my second attempt will get you closer.

Check out the excellent Knowledge Base article on [Ternary Operators](https://learn.knack.com/article/nsrud4si6l-equations)

How to Get the Fiscal Year [From a Date in Excel](https://thatexcelsite.com/fiscal-year-excel/)

Subscribe to my [YouTube channel](https://www.youtube.com/@chprojectsupport?sub_confirmation=1) for more tips and tricks 🚀

---

<div class="post-metadata">

**Author:** ![RCB](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/rcb/32/2371_2.png) [@RCB](https://forums.knack.com/u/RCB)\
**Post date:** [January 16, 2024, 5:49am UTC](https://forums.knack.com/t/financial-year-based-on-my-date-column/15474/4 "2024-01-16T05:49:20Z")

</div>

Works like a charm! Thanks @CarlHolmes, 🙂 and to your far more intelligent wife \<3

---

<div class="post-metadata">

**Author:** ![CarlHolmes](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/carlholmes/32/2814_2.png) [@CarlHolmes](https://forums.knack.com/u/CarlHolmes)\
**Post date:** [January 16, 2024, 7:21am UTC](https://forums.knack.com/t/financial-year-based-on-my-date-column/15474/5 "2024-01-16T07:21:05Z")

</div>

Thanks for the feedback @RCB - it was a bit of a brain teaser 🤔

---

<div class="post-metadata">

**Author:** ![CarlHolmes](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/carlholmes/32/2814_2.png) [@CarlHolmes](https://forums.knack.com/u/CarlHolmes)\
**Post date:** [January 19, 2025, 10:30pm UTC](https://forums.knack.com/t/financial-year-based-on-my-date-column/15474/6 "2025-01-19T22:30:32Z")

</div>

The original posts link has stopped working so just updating in case anyone stumbles across it.

https://www.loom.com/embed/dee909e65a1f4837a806909ab05661f4