Excel Function to return the day of the week for next birthday

I am trying to come up with an Excel formula which will return the weekday, Monday, Tuesday, etc., for the next birthday based on the date of birth of a person. I have used TEXT function, but what I get in return is the weekday when the person was born. What I am really looking for is to obtain the next year weekdays. Please refer to the attachment for example. In advance thank you for your time and help.

Try this,

=TEXT(DATE(YEAR(1&C2)+1,MONTH(B2),E2),"dddd")

Or,

=TEXT(EDATE(E2&C2,12),"dddd")

If you are on XL2003 or prior Analysis ToolPak AddIn needs to be activated to work EDATE

Yes Will work for any upcoming future birthdays.

How do you want this to work for future birthdays? Haseeb's formula will always look to the next calendar year....so for your September DOB the suggested formula gives you the 2012 day....but as soon as we hit 1st Jan 2012 that formula will change to show you the September 2013 day.

To always show the next Birthday (including today) you could use this formula

=DATE(YEAR(B2)+DATEDIF(B2,TODAY()-1,"y")+1,MONTH(B2),DAY(B2))

then you can format that to show day, month, weekday as required, see attached

Yes DLL. you are right, has not been think about DOB month & day about >TODAY(). Thank you for your effort.

kimston, I am sorry. my mistake. Mine wouldn't work for the future date as expected.

See the B5 DOB in DLL's example. Mine will give you 2012 result not 2011. 12/25/2011 has not been come yet. Proceed with DLL's method.