Featured Formulas

Filter data between dates

The goal is to extract records with dates that are greater than or equal to a start date in F5 and less than or equal to an end date in G5. You might think we can use the AND function inside FILTER to solve this problem. However, because AND returns...Read more

Featured Functions

STOCKHISTORY Function

The STOCKHISTORY function retrieves historical stock price information based on a given symbol and date range. The main purpose of STOCKHISTORY is to get the history of a financial instrument over time. Although the name suggests that STOCKHISTORY is meant to work only with stocks,...Read more

Recent Articles

LOVE your site... wow... you have helped me quickly do a lot of things that would have taken me forever to figure out on my own. And I love that your search feature actually knows what I'm looking for... lol
Morgan
Thank you for the great articles on LAMBA. You site is truly one of the last great websites that hasn't been destroyed by ads and AI, reminds me of the old days of the internet.
Justin
I have worked with Excel quite a bit over the past few years, and I really appreciate the information, examples, and tips that y'all have compiled. I find myself using formulas for very odd cases that may not be well covered elsewhere, and I have found my answers many times on Exceljet.net. Your articles and examples are usually quite thorough and well written.
Benjamin

Get Training

We offer free resources and paid training.

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed.

View Paid Training & Bundles

Just show me the free stuff

Excel 101 and Core Pivot Packages