You can set up conditional formatting in Excel for dates. We have included detailed examples you can try while reading the guide.

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.

The four functions covered here—ISOWEEKNUM, WEEKNUM, WORKDAY, WORKDAY.INTL—are complicated, so we’ll walk you through detailed instructions and examples.

Learn how to stop Excel from treating blank cells as zeros. Use IF, LET, ISBLANK, and LAMBDA functions to improve data accuracy. Excel blank ...