What is the Excel WEEKDAY Function? Excel WEEKDAY function returns an integer number between 1-7 representing the day of the week corresponding to a date. By default, WEEKDAY function returns 1 for Sunday and 7 for Saturday. Usually, the WEEKDAY function is used in other excel …
What is the Excel DATE Function? The DATE function returns a date by specifying the numerical year, month and day. The DATE function is the opposite of the DAY function, MONTH function and YEAR function that extracts the number of days, months and years from the …
What is the Excel YEAR Function? The Excel YEAR function returns the year corresponding to date as a 4-digit number starting from 1900 until 9999. Use the YEAR function to extract the year from a date into a cell. YEAR Syntax YEAR(serial_number) serial_number, required, a valid …
What is the Excel MONTH Function? The Excel MONTH function extracts the month number from a date, returns an integer number, ranging from 1 (January) to 12 (December). MONTH Syntax MONTH(serial_number) serial_number, required, a valid date in a format Excel recognizes. Usage Note: Excel returns a …
What is the Excel DAY Function? The DAY function returns integer numbers between 1 to 31 as the day of the months. Use the DAY function to extract a day number from a date. DAY Syntax DAY(serial_number) serial_number, required, a valid Excel date in serial number …
What is the DATEDIF function? The Excel DATEDIF function calculates the number of days, months or years between two dates. The Excel DATEDIF function is an undocumented function, even though in newer Excel versions you can find the DATEDIF function documentation in the Excel help menu. …
