IF Function (related to dates)

Hi @ all,

I have a formula issue where I would like to get your help.

As you can see I have a delivery cell which I would like to link to my "Financial Year" cell based on the following condition:

FY2020 = starting 01.01.2020 until 31.12.2020

FY2021 = starting 01.01.2021 until 31.12.2021

FY2022 =starting 01.01.2022 until 31.12.2022

and so on.

I have used the following approach but it didn't work out, can you please give me a helping hand here:

Thanks for your help guys!

Find more posts tagged with

Formulas

Cell linking

Accepted answers

Andrée Starå

Hi @Nico Kanthak

Try something like this instead.

=YEAR([Delivery Date]@row)

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

All comments

Andrée Starå

Hi @Nico Kanthak

Try something like this instead.

=YEAR([Delivery Date]@row)

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Nico Kanthak

Hi Andree,

thanks that worked perfectly, final question to complete this task, what would be the formula in case I have a book keeping year lets say

Start: 01.03.

Ends: 28.02.

How I can build the formula?

Cheers!

Andrée Starå

@Nico Kanthak

I hope you're well and safe!

Excuse the late response.

Glad to hear that it worked perfectly.

Crazy times and I missed coming back to you.

Have you solved the second question, or do you still need help?

Happy New Year & Stay safe!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.