Excel Formulas

Converts a serial number to a year

Converts a serial number to a month

Converts a serial number to a day of the month

Returns the number of days between two dates

Returns the ISO week number of the year for a given date

Returns the day of the week corresponding to a date, with custom weekend parameters

Returns a date before or after a specified number of workdays with custom weekend parameters

Calculates the fraction of the year represented by the number of whole days between two dates

Returns the serial number that represents the date that is the indicated number of months before or after a specified date

Returns the serial number for the last day of the month that is the indicated number of months before or after start_date

Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days

Returns a number that indicates where the week falls numerically within a year

Returns the ISO week number of the year for a given date

Calculates the number of days, months, or years between two dates

Calculates the number of days between two dates based on a 360-day year

Joins two or more text strings into one string

Combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined

Capitalizes the first letter in each word of a text value

Removes all spaces from text except for single spaces between words

Removes all nonprintable characters from text