TedJordan.Org - Logo

SUMIFS between two dates (Excel)

SumIF Function for Dates in Excek

SUMIFS between two dates, with multiple criteria or different types of criteria: learn how to use Excel conditional sum like a pro! If you don’t know what’s the difference between SUMIF and SUMIFS, this article is for you!

How to use SUMIF in Excel?

Sumif Function in Excel

We explain the SUMIF function in Excel by sharing several examples and showing you how its formula works for different types of criteria.

What is COUNT in Excel and how to use COUNT?

The different count functions in excel

Check how many cells contain numbers or data in your Excel table with COUNT and COUNTA functions! If you are wondering how many empty cells are in your table, read our tutorial until the end!

How to trim spaces in Excel

Trim Function Excel

Remove extra spaces quickly in your spreadsheets with the TRIM function! Watch our videos to learn from examples.

How many days before a date – Excel formulas

Today and Now Functions in Excel

Calculate the number of remaining days before a date in Excel easily with TODAY and NOW functions. Learn how to check when a worksheet was last refreshed or set deadlines automatically with these formulas.

How to get week numbers from dates in Excel

Weeknum function in Excel

Find any week number from a date value in Excel using WEEKNUM, DATE and ISOWEEKNUM functions. In business settings, we typically count in weeks so these handy formulas are a must for any analyst!

Excel: how to convert dates to days of the week?

Weekday Function in Excel

Do you want to know what day was a specific date? Or maybe you want to know what day will be the next bank holidays? Discover 2 great functions to use in Excel to do so! For past or future dates, they are the formulas to know to save time.