Birthday List Management System in Excel | Step by Step tutorial

Hello Friends,
In this video, we have explained how to create a Birthday List Management System in Excel. This is a dynamic Excel template. you can choose the criteria like - Birthday in next (days), Location or Department, accordingly it will return the birthday list data in sorted order.
Download the template file from below link:
www.pk-anexcel...
Subscribe our new KZbin Channel:
/ @neotechnavigators
Watch the Step by Step tutorial for Project Plan (Gantt Chart) in Excel
• Project Plan(Gantt Cha...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcel...
See our Excel Products:
www.pk-anexcel...
Visit to learn more:
Chart and Visualizations: www.pk-anexcel...
VBA Course: www.pk-anexcel...
Download useful Templates: www.pk-anexcel...
Dashboards: www.pk-anexcel...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
WWW.PK-AnExcel...
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/...
Pinterest:
/ pkanexcelexpert
LinkedIn:
/ pk-anexcelexpert
Twitter:
/ priyendra_kumar
Instagram:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/...

[@pandharinathjoshi6565]

Sir heavy technique Heavy knowledge sir No words to say sir💐💐💐🙏🙏🙏🙏 Just🙏👌💐

[@PKAnExcelExpert]

Thanks 🙏

[@Atusingh987]

Sir your video based on Advanced formula and techniques, but i request you to give a reason why use these formula so will understand more with logic. 🙏

[@erich2356]

Hi! Thanks for the great tutorial. I redid it myself, working almost perfect. If a colleague's birthday is in the next year e.g. in January 2025, they don't show up in the list. Is this a formula thing? How can I fix it that with next days=365 all birthdays show up? Thanks!

[@fragrenceful]

As you use for mula for location column,it is available in office 365only,if I don't have office 365 in my pc ,but I have office 2013and windows 7ultimate in this situation how to complete birthday list sheet or any alternative formula for office 2013, version please send or guide me ASAP step by step, thanks in advance

[@fragrenceful]

Sir good afternoon, I wouldlike to inform you that I don't have Microsoft 365, so I cannot use Unique formula and vstack formula, so how to do for location window in office 2007/2013 ? Please help me or guide me asap

[@mikeogieriakhi3394]

Thanks so much. I have done mine but each time I try copying the file to another location in my PC or to another PC, I affect the data in the excel sheet and it stops working. Please what should I do? And I can I open the file in a lower Microsoft Excel version, please show me how. Thanks

[@hinata6757]

hello, what if my employee name is in two columns like first name and last name. Upon searching, the names will be concatenated in 1 column. Thanks

[@fragrenceful]

Ye to company ke employee ka birthday list sheet hai, to kya aap personal name ke liye dynamic birthday list prepare kar sakte ho pk ? If you prepare this asap then I will be thankful for you otherwise this type list no use for us

[@rajeevsinghrathore4810]

Some formulae are not working with us . Why specially [ ]

[@fragrenceful]

How to prepare personal birthday list or table like this table? please guide me ASAP

[@rajeevsinghrathore4810]

Also facing problem while using =filter(Employee_Master,(Days_difference>=criteria_days)*Days difference

[@rajeevsinghrathore4810]

Is there any additional thing require to execute this function? Pls guide. Video is quite good but none of use if we can not use it

[@gurucool80]

Amazing....great work PK. You are a master of Excel functions and formulas 👏

[@PKAnExcelExpert]

Thanks 🙏

[@niteshjaiswal2754]

Excellent ❤

[@PKAnExcelExpert]

Thanks 😊

[@shahbazalikhan1825]

Mind blowing work!!!

[@PKAnExcelExpert]

Thank you so much 😀

[@abam9787]

create interactive excel without using name range challenge (impossible)

[@retechtamil7370]

Your video more informative thanks sir

[@PKAnExcelExpert]

Most welcome

[@AsifDawood]

Great video Thanks for sharing

[@PKAnExcelExpert]

Most welcome

[@johanneskeller3794]

tremendous proficiency

[@PKAnExcelExpert]

Thanks 🙏

[@johanneskeller3794]

tremendous proficiency

[@PKAnExcelExpert]

Thanks 🙏

[@rohitgurung909]

Nice and useful

[@PKAnExcelExpert]

Thanks a lot