IF formula Help

Hannahsamd

I need help with creating an IF statement for this criteria

I need a 1 if the Amendment column is populated and the Effective date is in January, a 0 if false

I am doing this for every month but need help creating this first one. I am creating a report out of this so I can sum them and get a subtotal for how many Amendments were created in January

Itai

Hey @Hannahsamd

Can you share a screenshot please?

Thank you!

Hannahsamd

@Itai

These are my columns

The formula I have right now is: =IF(AND([Amendment/Proposal Emailed]@row<>"'', [Program Effective Date] >1/1/23), 1, 0)

I am trying to make it so when the criteria is true it gives me a 1, if not 0, so later I can sum and see how many amendments were sent. I need the date to be only on January, only in february, etc.

Itai

Hey @Hannahsamd

I think I understand now. Try this formula:

=IF(AND([Amendment/proposal Emailed]@row <> "", [Program Effective date]@row > DATE(2023, 1, 1)), 1, 0)

It worked for me:

Hopefully that solves it for you.

Hannahsamd

@Itai I don't want it to be because I just want it to be the entire month of January. Like counting all of the amendments that were sent in the month of January. So if the date in that column is in january, there should be a 1 and if not then it should be a 0. It should be a column that analyzes every row. That is what I am struggling with

Hannahsamd

^^ and in 2023

Neil Watson

@Hannahsamd does this work?

=IF(AND([Amendment/proposal Emailed]@row <> "", MONTH([Program Effective Date]@row) = 1, YEAR([Program Effective Date]@row) = 2023), 1, 0)

Hannahsamd

@Neil Watson I am getting Invalid Data type

Neil Watson

@Hannahsamd are the effective program date & Amendment/proposal Emailed combs date type? And January column text?