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: functions
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”
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”
DAYS360 function
Function Type: Date and Time Description: DAYS360 function in Excel or Google Sheets is used to compute the number of days between 2 dates on a 360 days per year scale.This accounts for 12 months with 30 days for each12months x 30days = 360This is equivalent to subtracting an End Date and a Start Date,Continue reading “DAYS360 function”
DAYS function
Function Type: Date and Time Description: DAYS function in Excel or Google Sheets is used to compute the number of days between 2 dates.This is equivalent to subtracting an End Date and a Start Date. Function Structure: =DAYS(end_date,start_date) Arguments end_date – this is the date or serial number representing a the end date start_date –Continue reading “DAYS function”