WEEKDAY(serial_number, [return_type])
Description:Returns the day of the week for a specified date.
Example: =WEEKDAY(TODAY())
WORKDAY(start_date, days, [holidays])
Description: Returns the date before or after a specified number of workdays.
Example: =WORKDAY(TODAY(), 18)
DAYS(end_date, start_date)
Description: Returns the number of days between two dates.
Example: =DAYS("2025-12-31", TODAY())
DATEDIF(start_date, end_date, unit)
Description: Returns the difference between two dates based on the unit specified.
Example: =DATEDIF(TODAY(), "2025-12-31", "M")
EDATE(start_date, months)
Description:Returns the date that is a specified number of months before or after the start date.
Example: =DATE(TODAY(), 7)
EOMONTH(start_date, months)
Description: Returns the date of the last day of the month, a specified number of months before or after the start date.
Example: =EOMONTH(TODAY(), 3)
NETWORKDAYS(start_date, end_date, [holidays])
Description: Returns the number of whole workdays between two dates.
Example: =NETWORKDAYS(TODAY(), "2025-12-31")
NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
Description:Returns the number of whole workdays between two dates with customizable weekend parameters.
Example: =NETWORKDAYS.INTL(TODAY(), "2025-12-31", 1)