How to add date condition to IF/AND equation

mpajuelo

I have multiple IF/AND equations in a column formula. I want to add a condition to the IF/AND equations to apply before a certain date in a column(Date of Shoot). This is an example of one of the formulas:

IF(AND(Talent@row = "Agency", Time@row = "Half", [Date of Shoot]@row < DATE(2023, 9, 16), 250

But is shows as "incorrect argument"

DKazatsky2

Hi @mpajuelo

You are missing 2 closed parens. Try the below.

=IF(AND(Talent@row = "Agency", Time@row = "Half", [Date of Shoot]@row < DATE(2023, 9, 16)), 250)

Hope this helps,

Dave

DKazatsky2

Hi @mpajuelo

You are missing 2 closed parens. Try the below.

=IF(AND(Talent@row = "Agency", Time@row = "Half", [Date of Shoot]@row < DATE(2023, 9, 16)), 250)

Hope this helps,

Dave

mpajuelo

It works, thank you!