Semimonthly pay schedule
To create a list of pay dates that occur twice a month on regular days, you can use a formula based on the FILTER function and the SEQUENCE function. In the example shown, the formula in cell D5 is: …Read more
Learn Excel with clear examples and bite-sized videos.
Featured Functions
TEXTBEFORE Function
The Excel TEXTBEFORE function returns the text that occurs before a given substring or delimiter. In cases where multiple delimiters appear in the text, TEXTBEFORE can return text before the nth occurrence of the delimiter.Read more
Recent Articles
Combinations and permutations in Excel
Combinations and permutations are two basic ways to count possibilities, used in probability, statistics, games, passwords, and lotteries. This article explains the difference between them, when order and repetition matter, and the Excel functions you can use to calculate each case: FACT, PERMUT, …Read more
Topics By Category
User Testimonials
Just a big thank you for the info regarding Vlookup text & numbers conversion not working. What a relief to find yet another answer to the excel minefield. Great site and always recommend it to my colleagues.
Phil
This website is always helping me be better at my work. I just go on google, make a search, and more often than not I end up here. Great work!
Vasco
Just wanted to drop you a short e-mail to say how useful I have found several of you video tutorials. Thank you! I really found the "Choose" function video especially useful in applying financial quarters (UK!) and this led me on to finding formulas for financial year.
Paul
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.
