Excel Forum

YTLE#100: Array Formula Database Customer Evaluation

See how to create an array formula to evaluate whether customers from a transactional database (where customers are listed multiple times) have ordered in the last 6 months.

Also see how to use the TODAY and EDATE function to calculate the exact number of days between any six month period.

Also see the functions: IF, MAX, TODAY and EDATE.

Got a Question? Ask it Here in the Forum.