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”
Tag Archives: formula
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”
EOMONTH function
Function Type: Date and Time Description: EOMONTH function in Excel or Google Sheets is used to return the serial number of the last day of the month before or after a specified number of months. Function Structure: =EDATE(start_date,months) Arguments start_date – this is the date or serial number representing the start date in a validContinue reading “EOMONTH function”
How to do Dynamic Dropdown without blanks in Excel step by step guide
As I am revising my excel template for Retail Inventory, I realized there might be some people out there needing help or guide on how to use a dynamic dropdown, but do not want to include the blanks. Sample Problem Description 1: I want to make a dropdown list in excel using Setup!$C$15:$C$44 range butContinue reading “How to do Dynamic Dropdown without blanks in Excel step by step guide”
EDATE function
Function Type: Date and Time Description: EDATE function in Excel or Google Sheets is used to return the serial number of the date that is the indicated number of months before or after the start date. Function Structure: =EDATE(start_date,months) Arguments start_date – this is the date or serial number representing the start date months –Continue reading “EDATE function”