Function Type: Date and Time Description: WEEKDAY function in Excel or Google Sheets is used to convert a serial number to a day of the week. Function Structure: =WEEKDAY(serial_number,[return_type]) Arguments serial_number – The date for which you want to get the day of week.[return_type] – A number representing day of week mapping scheme. Default isContinue reading “WEEKDAY function”
Tag Archives: microsoft excel expert
YEAR function
Function Type: Date and Time Description: YEAR function in Excel or Google Sheets converts a serial number of a date to a day of the month.It returns an integer from 1990 to future years. You can use YEAR function to get the MONTH number from your TODAY function or NOW function which can be usedContinue reading “YEAR function”
MONTH function
Function Type: Date and Time Description: MONTH function in Excel or Google Sheets converts a serial number of a date to a day of the month.It returns an integer from 1-12 as we see in calendars. You can use MONTH function to get the MONTH number from your TODAY function or NOW function which canContinue reading “MONTH function”
DAY function
Function Type: Date and Time Description: DAY function in Excel or Google Sheets converts a serial number of a date to a day of the month.It returns an integer from 1-31 as we see in calendars. You can use DAY function to get the DAY number from your TODAY function or NOW function which canContinue reading “DAY function”