IF Function (related to dates)

Nico Kanthak

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!

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!

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!

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!