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

If you need to count or calculate number of Leap Years between two dates in Excel or list of two dates in Excel, make use of this formula to get things done.

After you've assembled all your financial data and created a worksheet to contain your income in one column and your expenses in another, you can use Excel's "SUM" function to create a formula to ...