Bookkeepers, project managers, HR departments and more use the Excel Date & Time functions WEEKNUM, ISOWEEKNUM, WORKDAY, WORKDAY.INTL to calculate time. Here's how.

The IF function is one of the most flexible functions in Microsoft Excel and has a range of uses that can be helpful in comparing data entries and isolating specific data points. The IF function can ...

If Microsoft Excel does not recognize dates, then there is something wrong with the formatting. Use any of the methods mentioned here to format cells perfectly.

In this post, we will show you how to calculate the expiry date in Microsoft Excel. Calculating expiry dates is a common requirement when working with Excel, especially for tracking inventory ...

Excel is a very handy tool for working with data. It has many built-in features, like conditional formatting, which helps you to format and highlight data based on certain rules. The rules can be ...

Excel for the web now supports conditional formatting, and the interface is easier to use than the desktop edition. Susan Harkins shows you how to use it.

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.

If you have to work with a date stamp in Microsoft Excel that includes date and time, you can use these simple expressions to extract both components, making them easier to work with.

Randomly Generate Dates in Excel. Creating a series of random dates in Excel allows you to test your spreadsheet's functions on a variety of dates or look at projections for a range of future dates.