An Excel date formula to log today's date, and a keyboard shortcut to add the current time Microsoft Excel can basically do anything with data, if you just know how. This tutorial is another key step to adding skills to your Excel toolbelt. May 13, 2019 · One of Microsoft Excel's best-known date functions is the NOW function. The NOW function adds the current date or time to a worksheet. It can also be used in date and time formulas to find the number of day past the current date, the number of days to the end of the month, and the current minute. To enter today's date in Excel, use the TODAY function. To enter the current date and time, use the NOW function. To enter the current date and time as a static value, use keyboard shortcuts. 1. To enter today's date in Excel, use the TODAY function. Note: the TODAY function takes no arguments. This ...

Formula Explanation:-. (IF(LEFT(A2,2)*1<20,2000,1900)+LEFT(A2,2))) :- This part of formula will help to get the year. MOD(A2,1000) :- This part of formula will help to get the number of days. By using rest part formula will calculate the date as number, because excel has stored the date as numbers.