Excel Forum
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




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.