Hi, I'm trying to create a table to display birthdays in the next xxx days, I guess a pivot table is the easiest way to do this.
I have a list of data:
I now need to create a list of the birthdays that are coming up in the next xxx (say 28) days. If needbe I have worked out a forumula to calculate Next Birthday, days to go and age on next birthday as follow:Please Login or Register to view this content.
Next B-Day:Days to go:Please Login or Register to view this content.
Next Age: =INT(($C$1-C3)/365)+1Please Login or Register to view this content.
Whats the easiest way to achieve this? All I want is something that will go through my list of data and pick out the people who have birthdays in the next xxx days, after that I intend to some how add a hyperlink that will email them.
Dummy spreadsheet attached.
Bookmarks