Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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
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"
)
