If you would like to improve your Excel workflows and spreadsheets and in the process save a huge amount of time you might be interested in mastering Excel date functions. Once mastered this ...

As I showed in my first Excel functions article, the serious meat in any spreadsheet is the formulas and functions that perform the calculations. Excel offers functions that you can use to make the ...

How to Make a Cell on Microsoft Excel With a Changing Date. Microsoft Excel offers a Function Library with formulas that insert the current date when you open the worksheet or enter calculations.

This Technology Workshop illustrates how to leverage a number of functions to perform calculations in Excel involving the time value of money.

If you have to work with a date stamp in Microsoft Excel that includes date and time, you can use these simple expressions to extract both components, making them easier to work with.

If you need a monthly or yearly balance for revenue transactions in Microsoft Excel, you're in luck because both are easy! Here's how to find the totals you need.

How to Auto-Format the Date in MS Excel. When you create Microsoft Excel spreadsheets that contain one or more columns of dates, you can make things a bit easier if you pre-format your cells to ...

DATEDIF(), which means Date + Dif, is a compatibility function left over from Lotus 1-2-3 that Microsoft adopted in Excel version 2000. It's fallen off current Excel menus, but you can still use ...