NVRensburg
Board Regular
- Joined
- Jul 1, 2014
- Messages
- 108
- Office Version
- 365
- 2016
- Platform
- Windows
Good Morning
Please could I get some help with a formula to find birthday's from a list that match a date. To be more specific
Tab "Staff" A2:B24" is the table that has column "A" Birthday Date" in Format DD/MM and Column B has the staff members name
Tab Sheet 1 has a roster in where B:3 to G:4 has Monday to Sunday above and the date in format DD/MM/YYYY. In cell B3 I want the formula to look at the date in B1 and match it to the date in Staff Tab and return the name of who's birthday it is, if applicable. But the formula will need to know to match just the DD MM not the year, as otherwise it won't match.
Not sure if I'm making any sense?
Please could I get some help with a formula to find birthday's from a list that match a date. To be more specific
Tab "Staff" A2:B24" is the table that has column "A" Birthday Date" in Format DD/MM and Column B has the staff members name
Tab Sheet 1 has a roster in where B:3 to G:4 has Monday to Sunday above and the date in format DD/MM/YYYY. In cell B3 I want the formula to look at the date in B1 and match it to the date in Staff Tab and return the name of who's birthday it is, if applicable. But the formula will need to know to match just the DD MM not the year, as otherwise it won't match.
Not sure if I'm making any sense?