list of upcoming birthday this month and next month

Greetings for the day guys.

in the attached worksheet I have the details of the staff birthday table on the left hand and I already converted the birthdays to match the current year in column "G", however, I'm still looking for a formula in the right-hand table to list for me the upcoming birthdays for the current month and next month.

I look forward to hearing back from you.

I have attached a screenshot of the worksheet as well as the workbook is also being attached for reference.

thank you so much in advance.

Book1---9.xlsx

548TY85468.jpg

Originally Posted by Glenn Kennedy

K4, copied across and down:

=IFERROR(INDEX(C:C,AGGREGATE(15,6,ROW(Table9[[NAME]:[NAME]])/((Table9[[MONTH]:[MONTH]]=TEXT($C$2,"m")+0)+(Table9[[MONTH]:[MONTH]]=1+TEXT($C$2,"m")+0)),ROWS(K$4:K4))),"")

Brother this is amazing work, the formula is working perfectly.

thank you so much brother, much appreciated.

Originally Posted by sandy666

maybe sort MONTH / DAY ascending
or use Power Query

NAME	BIRHTDATE	DAY	MONTH	BIRTHDAY2	AGE
GHUFRAN ULLAH	01/01/1991	1	1	01/01/2023	32
MAGED NAJI AHMED	01/01/1985	1	1	01/01/2023	38
SAHALAH NAMUGERWA	25/02/1996	25	2	25/02/2023	27

Please Login or Register  to view this content.

thank you, brother, for your help as well much appreciated, actually I'm more into formula than power query, but really much appreciated your alternate proposal.

highly appreciated.

my pleasure
have a nice day