Excel Forum
Similar Content
Introduction to Using Filters to Refine Data in Excel
Tutorial: Filtering allows you to hide rows of data which you are not interested in so that you can ...
Get the Day of Week from a Date in Excel
Tutorial: How to get the name of a day from a date in Excel. This returns, for example, "Tuesday" fo...
Years, Months, Days Between two dates in Excel
Tutorial: I have found a rather convoluted method to Calculate the Number of Years, Months and Days ...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




Excel Magic Trick 165p2 MACRO Advanced Filter Extract B-days


Part 2 shows the MACRO and Advanced Filter and the Forms button.
See the INDIRECT, ROW, TEXT and OR functions in a TRUE FALSE formula that will help to extract records of people who have a birthday in the next 14 days. See Advanced Filter and How to Create a MACRO and then add it to a Form button on the worksheet.
Also see: From a beginning and ending date, see how to create a list of dates (serial numbers) in memory using the ROW and INDIRECT functions: Excel MT142 p2: Array Formula for Counting Dates.
Start Advanced Filter From One Sheet and Go To Another sheet.





Got a Question? Ask it Here in the Forum.