Combine 2 IF formulas

Samad

Hi,

Can someone help me with combining these 2 formulas? 

 

=IF(MONTH([Date Raised]12) = MONTH([Date Raised]1), "Yes", "No")

and

=IF(YEAR([Date Raised]12) = YEAR([Date Raised]1), "Yes", "No")

 

Regards,

 

Samad

Adam Overton

If you want both to be true, you can use the AND() function.

=IF(AND(MONTH([Date Raised]12) = MONTH([Date Raised]1),YEAR([Date Raised]12) = YEAR([Date Raised]1)), "Yes", "No")

Formatted another way:

=IF(

           AND(

                       MONTH([Date Raised]12) = MONTH([Date Raised]1),

                       YEAR([Date Raised]12) = YEAR([Date Raised]1)

                   ),

         "Yes", "No"

     )