The EOMONTH Function
It returns the last day of the month that is a given number of months before or after the specified date.
0205, 2019
Tag Archives: Date & Time
0205, 2019
The EDATE Function
It returns the date that is a given number of months before or after the specified date.
0205, 2019
The WORKDAY.INTL Function
It returns the date that is the given number of days before or after the starting date. Weekends and holidays are excluded. The difference with the WORKDAY function is that it allows custom weekend days.
0205, 2019
The WORKDAY Function
It returns the date that is the given number of days before or after the starting date. Weekends and holidays are excluded.
0205, 2019
The WEEKDAY Function
It returns the day of the week corresponding to a date. The day is given as an integer, ranging from 1 to 7.
0205, 2019
The TIMEVALUE Function
It converts a text value to the time format that Excel recognizes. This is a decimal number ranging from 0 (zero) to 0.99988426, representing the times from 0:00:00 (12:00:00 AM) to 23:59:59 (11:59:59 P.M.).
0205, 2019
The NETWORKDAYS Function
Calculates the number of whole working days between two dates. This means that weekends and holidays are excluded.
0205, 2019
The DAYS Function
Calculates the number of days between two dates.
0205, 2019
The DATEVALUE Function
It converts a text value to the date format that Excel recognizes (serial number).
0205, 2019
The DATEDIF Function
Calculates the number of days, months, or years between two dates. This function is only provided for compatibility with older Lotus 1-2-3 workbooks. It is a hidden function and will not appear in Excel’s autocomplete.
