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.

Set Current Date in Excel The easiest way to add the current date in Excel is to simply type the date. For instance, typing "2018-07-31" in a cell is automatically detected as a date.

Launch Microsoft Excel and enter a date in an empty cell. Excel automatically recognizes common formats, such as "3/17/2012," "Mar 17, 2012" or "17 Mar 2012." ...

For example, if you want to add 9-7-2000 but it is getting changed to date 09-07-2000, you can add an apostrophe before the number like ‘9-7-2000. It will be shown as 9-7-2000.

2] Using the DAYS function DAYS is a date function in Excel that calculates the difference between two given dates in days. It can recognize dates passed as ‘strings’ if they can be parsed as ...