IF(And = I have tried this several times Could anyone help

I need to update a value in a new column.

How would I look at a date column that shows dates between 01/01/2025 to 03/31/2025 and place the value of Q1_2025 into another cell?

Q1_2025 is working as it should. The others do not. I tried doing one quarter at a time; however, I still get a message that it is incorrect.

=IF(AND([BNP PARIBAS Paid Date (Workflow Trigger)]@row >= DATE(2025, 1, 1), [BNP PARIBAS Paid Date (Workflow Trigger)]@row <= DATE(2025, 3, 31)),"Q1_2025"),

IF(AND([BNP PARIBAS Paid Date (Workflow Trigger)]@row>=DATE(2025,4,1),[BNP PARIBAS Paid Date (Workflow Trigger)]@row<=DATE(2025,6,30)),"Q2_2025”),

IF(AND([BNP PARIBAS Paid Date (Workflow Trigger)]@row>=DATE(2025,7,1),[BNP PARIBAS Paid Date (Workflow Trigger)]@row<=DATE(2025,9,30)),"Q3_2025”),

IF(AND([BNP PARIBAS Paid Date (Workflow Trigger)]@row>=DATE(2025,10,1)),([BNP PARIBAS Paid Date (Workflow Trigger)]@row,DATE(2025,12,31),"Q4_2025"))))

Find more posts tagged with

Formulas

Accepted answers

DKazatsky2

Hi @cswicegood,

You have the syntax a bit off, you are closing the IF statements after the "true" condition. Try the following.

=IF(AND([BNP PARIBAS Paid Date (Workflow Trigger)]@row >= DATE(2025, 1, 1), [BNP PARIBAS Paid Date (Workflow Trigger)]@row <= DATE(2025, 3, 31)), "Q1_2005", IF(AND([BNP PARIBAS Paid Date (Workflow Trigger)]@row >= DATE(2025, 4, 1), [BNP PARIBAS Paid Date (Workflow Trigger)]@row <= DATE(2025, 6, 30)), "Q2_2025", IF(AND([BNP PARIBAS Paid Date (Workflow Trigger)]@row >= DATE(2025, 7, 1), [BNP PARIBAS Paid Date (Workflow Trigger)]@row <= DATE(2025, 9, 30)), "Q3_2025", IF(AND([BNP PARIBAS Paid Date (Workflow Trigger)]@row >= DATE(2025, 10, 1), [BNP PARIBAS Paid Date (Workflow Trigger)]@row <= DATE(2025, 12, 31)), "Q4_2025"))))

Hope this helps,

Dave

All comments

DKazatsky2

Hi @cswicegood,

You have the syntax a bit off, you are closing the IF statements after the "true" condition. Try the following.

Hope this helps,

Dave

cswicegood

Thank you.

Very helpful

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.