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.

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.

Use Microsoft Excel's TODAY() function in simple expressions to highlight the current date and past and future dates.