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

cswicegood

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"))))

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

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

cswicegood

Thank you.

Very helpful