The EOMONTH function in Microsoft Excel returns the last day of a month in the past, the current month, or a month in the ...

Excel offers several easy ways to calculate expiry dates. This post explores different ways to automate expiry date calculations in Excel.

Since each date is really just a number stored in Excel, to compute the midpoint of two dates you would use the same mathematical formulas you would use to calculate the midpoint of two numbers ...

All businesses need to calculate dates and times for payroll, expenses, inventory and more. We show how Excel turns dates into serial numbers for easier calculations, and we discuss Networkdays ...

Calculating Date Differences with DATEDIF The DATEDIF function is a versatile tool for calculating the difference between two dates in days, months, or years. This function is particularly useful for: ...

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.

The article How to calculate conditional subtotals in an Excel revenue sheet uses simple expressions, a function, and a conditional format to display a daily balance in a revenue sheet.