get nearest month/day/year that hasn't passed from two digit number with formula

[951Michael]

Hello everyone,

I need a formula that can get the nearest month/day/year from a two digit day. It also cannot by a month/day/year that is in the future. So lets say today is 12/01/2017 and I have two digit numbers of 28, 11, and 01. I would then get back these dates: 11/28/2017, 11/11/2017, and 12/01/2017.

Thanks a lot for the help

[CK76]

Assuming 28,11,1 in A2:A4.
B1: =Today()

B2: =DATE(YEAR($B$1),MONTH($B$1)-1*(DAY($B$1)<A2),DAY(A2))
Copy down.

Edit: If it's two digit number stored as text. Replace A2 with A2*1. To coerce text into number.