How to use Excel YEAR function

Introduction YEAR function in Excel is a type of DATE/TIME function. It used to find YEAR of a specified date. It can be used to supply YEAR into a cell or used with functions like DATE function as a feeder. Syntax =YEAR( Date ) Arguments Date:- A date in a valid excel format. Can be entered using DATE function, If dates in form of text are entered then there is a possibility of getting an error.   Keynotes In General…

Continue Reading

How to use Excel YEARFRAC function

Introduction YEARFRAC function in Excel is a type of DATE/TIME function. It used to find year between two dates which can also be in form of a fraction and result can be in form of decimals. It is a worksheet function and can be entered in a cell. Syntax =YEARFRAC(Start_Date, End_Date, Basis) Arguments Start_Date:- A starting date in a valid excel format. Can be entered using DATE function, if dates in form of text are entered then there is a…

Continue Reading

How to use Excel HOUR Function

Introduction HOUR function in Excel is a type of DATE/TIME function. This function is used to find hours from a given time. It gives result in form of numbers ranging from 0(12:00 AM) to 23(11:00 PM). For example, for time 10:15 AM, HOUR function will retrieve 10. HOUR function can also be used with the TIME function for feeding hours into this function. Syntax =HOUR(Serial_Number) Arguments Serial_Number- This is time in a valid excel format. Keynotes Time values are represented…

Continue Reading

How to use excel DATEVALUE function

Introduction DATEVALUE function in Excel is a type of DATEVALUE/TIME function. This function is used to change a date which is in form of text to a valid excel format and gives result in form of serial number in the Excel date system. For example, formula =DATEVALUE(12/09/2018) gives 43443 as the result.  Syntax =DATEVALUE(Date_Text) Arguments Date_Text-  It is the text or cell reference which represents the date value in valid excel format. Keynotes In General formatting of Excel, DATEVALUE function…

Continue Reading

How to use Excel DAYS Function

Introduction DAYS function in Excel is a type of DATE/TIME function. It gives value of the number of days falling between two dates. This function can be applied to find the number of the DAYS from the date present in the cell. This can also be used to extract and put the number of the DAYS into other functions, for example in DATE function. Syntax =DAYS(end_date,start_date) Arguments End_Date- The end date to which one wants to calculate the number of…

Continue Reading

How to use Excel DAYS360 Function

Introduction DAYS360 function in Excel is a type of DATE/TIME function. It gives value of the number of days falling between two dates by considering a 360 days year. It does so by considering every month of the year to be consisting of 30 days. This function can be applied to find the number of the days from the date present in the cell. This can also be used to extract and put the number of the days into other…

Continue Reading

How to use Excel NOW function

Introduction NOW function in Excel is a type of DATE/TIME function. This function is used to retrieve present date with time. It is a dynamic function and updates automatically when we change a is made to the file or it is reopened. It gives result in form of serial number which can be formatted in form of date or date with time by using number format. Syntax =NOW() Arguments NOW requires no arguments, but parenthesis are required Keynotes In General…

Continue Reading

How to use Excel WORKDAY function

Introduction WORKDAY function in Excel is a type of DATE/TIME function. This function is used to retrieve a date which represents a number of working days in future or past of a specified date. This function also omits any holidays or weekends which are specified in the syntax. This function was introduced in Excel 2007 and is built in later versions. For use in versions earlier than Excel 2007, Analysis ToolPak needs to be enabled. Syntax =WORKDAY( Start_Date,Days,Holiday ) Arguments…

Continue Reading

How to use Excel MONTH function

Introduction        MONTH function in Excel is a type of DATE/TIME function. It used to obtain find month of a specified date. It returns a serial number in integer form (1 for Jan. up to 12 for Dec). It can be used to supply month into a cell or used with functions like DATE function as a feeder. Syntax =MONTH( Date ) Arguments Date:- A date in a valid excel format. Can be entered using DATE function, If dates in form…

Continue Reading

How to use Excel EOMONTH function

Introduction EOMONTH function in Excel is a type of DATE/TIME function. It used to obtain last date of a month. This date can be of the present month or a month in past and future. It returns a serial number which can be formatted into a readable form. It can be used to calculate due dates falling on last date of a month. It can also be used with EDATE function. Syntax =EOMONTH( Start_Date, Months ) Arguments Start_Date:- A date…

Continue Reading
Close Menu
×

Cart