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

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.

Learn how to create date lists in Excel using autofill, formulas, and advanced techniques. Save time and boost efficiency with these tips ...

Do you use Excel spreadsheets to keep track of your weekly, monthly or annual expenses but find yourself updating all relevant date and content information manually? There is an easier, more effective ...

Excel's data validation feature is more versatile than you might think. Learn how to use literal values, input values, list values, and even formulas to restrict input date values using data ...

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 ...

As a result, using the WEEKDAY function to calculate days of the week for dates in 1900 before March 1 yields incorrect results in Microsoft Excel worksheets built using the 1900 date system.