We've been learning about dates in Excel for nearly two weeks now, so let's bring it all together with a formula that builds dates from year, month, and day pieces. I'll give you three guesses what our friends at Microsoft decided to call this function...
Surprise, surprise... the DATE() function! Knowing how it works won't score you more dates necessarily, but it will allow you to take someone's birth date and turn it into a current-year birthday!
Let's take this in pieces. First we use the MONTH() function to get the month on its own.
Next, we do the same thing with the DAY() function.
Now we can use DATE() and feed it the current year (2016) along with the precalculated month and day to get our current-year birthday!