Excel’s Date & Time functions ease the workload for bookkeepers, project planners, HR departments, and other jobs where time is money. The four functions covered here—ISOWEEKNUM, WEEKNUM ...

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

Both EDATE and EOMONTH calculate dates in a month. In this tutorial, we are going to explain how to use EDATE and EOMONTH in Excel.

This post shows how to use the TRUNC function in Excel. Use it to remove or truncate decimals, time from date-time format, etc. It is the opposite of Round.

For example, =EOMONTH(W1, 1) will return the last day of the month that is one month after the date in cell W1. EDATE: The EDATE function adjusts a given date by a specified number of months.