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.