Date & Time(Microsoft Excel Functions)

Functions Functions to manipulate date and time. Function Importance Description WORKDAYWORKDAY.INTL High Get the date (serial value) after the specified number of business days. EDATE High Get a date (serial value) after the specified month, taking into account the last day of the month. Function to get the date and time. Function Importance Description DATE High Get date (serial value) by specifying year, month, and day. TIME High Get time (serial value) by specifying hour, minute, and second. TODAY High Get the date(serial value) of the day. NOW High Get the current date and time (serial value). EOMONTH High Get the end-of-month date (serial value). DATEVALUE High Converts a string … Continue reading Date & Time(Microsoft Excel Functions)