Function Type: Date and Time Description: WEEKNUM function in Excel or Google Sheets Converts a serial number to a number representing where the week falls numerically with a year. This function is useful in formulas when you need to know the week number, especially when you’re in the middle of the year where it getsContinue reading “WEEKNUM function”
Category Archives: Spreadsheet Tutorials — Excel and Google Sheets for Personal Finance
NETWORKDAYS function
Function Type: Date and Time Description: NETWORKDAYS function in Excel or Google Sheets calculates the number of whole workdays between two dates. This function is useful in formulas where you need to calculate the number of weekdays or commonly known as business days. It will exclude the number of weekends in between the 2 datesContinue reading “NETWORKDAYS function”
TIMEVALUE
Function Type: Date and Time Description: TIMEVALUE function in Excel or Google Sheets is used to convert a time in the form of text to a serial number. This is best used when you have separate cells / placeholders for Hours, Minutes, and Seconds. It works even when you only have Hours and Minutes, itContinue reading “TIMEVALUE”
DATEVALUE function
Function Type: Date and Time Description: DATEVALUE function in Excel or Google Sheets is used to convert a date in the form of text to a serial number. This is best used when you have separate cells / placeholders for Month, Date, and Year. It works when you only have Month and Date, it willContinue reading “DATEVALUE function”
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”
SECOND function
Function Type: Date and Time Description: SECOND function in Excel or Google Sheets is used to convert a serial number to seconds. “SECOND” returns only the seconds of the serial number, it ignores the hours and minutes. Seconds resets on 60-minute clock so if the serial number is more than 60 it will be likeContinue reading “SECOND function”
MINUTE function
Function Type: Date and Time Description: MINUTE function in Excel or Google Sheets is used to convert a serial number to a minute. “MINUTE” returns only the minute of the serial number, it ignores the hours and seconds. Minutes resets on 60-minute clock so if the serial number is more than 60 it will beContinue reading “MINUTE function”
HOUR function
Function Type: Date and Time Description: HOUR function in Excel or Google Sheets is used to convert a serial number to an hour. “HOUR” returns only the hour of the serial number, it ignores the minutes and seconds. Hours resets on 24-hour clock so if the serial number is more than 24 it will beContinue reading “HOUR function”