Year Formula Partially Works

Welcome to the Forum PeterGeeJA!

This formula in C8 refers to itself which creates a circular reference. Are you doing that deliberately?

Formula:

Please Login or Register  to view this content.

There is nothing in the formula to reflect this. Not sure why you expect that to happen.

We need more context. We can't diagnose one particular little issue when we don't know what you want your formula do to. The circular reference is also confusing without more context. Can you provide the file that uses this and explain the entirety of what you want this formula to do? Here is the breakdown of you current logic:

Please Login or Register  to view this content.

By the way, instead of converting the year to text, you should be using a numeric value. Change all occurrences of
TEXT(TODAY(),"yyyy")
to
YEAR(TODAY())

What is in D12? That should be numeric too.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so. Cross-posts are allowed but you must provide a link to your posts on other sites.

Please see Forum Rule #7 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

I am providing the link because it's your first post.

https://www.mrexcel.com/board/thread...works.1256210/

And here: https://forums.excelguru.ca/threads/...y-works.11838/