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 Day Name 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 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.