Tag Archives: Excel Expert

WEEKDAY function

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”

TIME function

Function Type: Date and Time Description: TIME function in Excel or Google Sheets is used to return the serial number of a particular time. Function Structure:  =TIME(hour,minute,second) Arguments  hour – an integer from 0 to 24minute – an integer from 0 to 60second – an integer from 0 to 60 Examples  Still need help withContinue reading “TIME function”