Date match formula

Corporate Corporate

Cross reference sheet formula, I am trying to return the value of a cell when the date matches my current month formula. I am sure this does not make sense, see screenshot.

VBAGuru

=IF(AND(MONTH(TODAY()) = MONTH([Date]@row ), YEAR(TODAY()) = YEAR([Date]@row )), [Revenue Variance Explanation]@row , "")

I added in the year in case this is a running list.

Corporate Corporate

thank you so much!!! I will try it…