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
Help Article Resources
Check out the Formula Handbook template!