IF formula Help
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
Answers

Itai Perez
Project Manager  Transformation Department
Gong cha
If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂

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.

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.
Itai Perez
Project Manager  Transformation Department
Gong cha
If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂

@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

^^ and in 2023

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

@Neil Watson I am getting Invalid Data type

@Hannahsamd are the effective program date & Amendment/proposal Emailed combs date type? And January column text?
Help Article Resources
Categories
Check out the Formula Handbook template!