On 2/24/2019 10:01 AM, dpb wrote:
....

=DATE(YEAR(TODAY())+N(DATE(YEAR(TODAY()),MONTH(A1) ,DAY(A1))=TODAY()),MONTH(A1),DAY(A1)))


is off-the-cuff recast...untested.Â* Particularly check for matching
parentheses.

And indeed, the logic test is reversed in the above..


=DATE(YEAR(TODAY())+N(DATE(YEAR(TODAY()),MONTH(A1) ,DAY(A1))TODAY()),MONTH(A1),DAY(A1)))


--