How can I add or subtract months from a date using the EDATE function in Excel? To use the EDATE function you will need the starting date and the number of months to add or subtract.

How to add a monthly balance in Excel As you’ve seen, a daily balance requires only a simple IF () function to match dates before returning the balance for each day.

How to Calculate the Midpoint of Two Dates in Excel. When you enter a number into an Excel cell that looks like a date, such as "Jun-1" or "6/1," Excel automatically adjusts the format of the cell ...

It's easy to change the date format in Microsoft Excel. You just need to use the "Date" drop-down menu, which gives you plenty of options.

Microsoft Word has a date field, but it's not easy to use in an expression. If you need to update dates in a document, use Excel to calculate the dates and then run a mail merge.