Excel may return a serial number instead of a date; because it is stored thus in the backend. Learn how to convert Serial Number to Date.

The DEC2BIN function in Microsoft Excel is an Engineering function, and its purpose is to convert a decimal number to binary. The formula for the DEC2BIN is DEC2BIN( Number, [Places]).

In addition to its basic spreadsheet functions, Microsoft Excel also allows writing formulas to perform functions on existing data. Using a quick equation, you can convert an existing set of time ...

How to Convert Dates to Years in Excel. When you use Microsoft Excel to store and analyze business data, your workbooks and worksheets often contain date information. Although your original data ...

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.