Excel Forum



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.