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 165p1 MACRO Advanced Filter Extract B-days


Part 1 Shows TRUE FALSE formula for a Series of Dates using the ROW and INDIRECT functions.
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.

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





Got a Question? Ask it Here in the Forum.