Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.

Microsoft Excel's Formula by Example helps automate repetitive tasks in structured tables in Excel for the Web. The tool is ...

In this example, youre combining all ... You can also create sequences in multiple columns, or even use it for dates and ...

Excel’s Date & Time functions ease the workload for bookkeepers, project planners, HR departments, and other jobs where time is money. The four functions covered here—ISOWEEKNUM, WEEKNUM ...

2. Sort Function. The Sort Excel function is a powerful tool for organizing and arranging your data in a meaningful order. Whether you need to sort numbers, text, or dates, this function has you ...

This formula will count the number of cells in the range A1:A100 that fall between the dates 1/1/2023 and 12/31/2023, and have a corresponding value greater than 1000 in the range B1:B100. Use ...

This post shows how to use the TRUNC function in Excel. Use it to remove or truncate decimals, time from date-time format, etc. It is the opposite of Round.