title: Excel convert DOB to DOB-related expiration date
body: <p>I have various peoples' DOBs. I want to convert them to a format that will serve as their predicted-but-incomplete NY Driver's License expiration date (which is always the person's DOB in some later year). Because (for now) all of the license expiration dates will be sometime before 2030, I would like to essentially chop off the year portion of the DOBs and replace them with &quot;202_&quot; (or if that's not feasible then just &quot;202&quot;).</p>
  <p>I know how to get Excel to display the DOB without the year, but that isn't helping me so far. My hope had been to use CONCAT to start with that truncated display and then just add &quot;202_&quot; but the date format of the truncated DOB is tripping me up. If I could get Excel to treat the truncated/display DOB as text without Excel converting it to its number version of the whole DOB then that would seem to solve the problem... Or maybe there's another approach I haven't thought of yet?</p>