The HOUR function is categorized as a DATE/TIME function in Excel and extracts the hour component of a time. It returns a value between 0–23. You can use the HOUR function on its own or use it along with another function by passing the extracted HOUR part as a relayed result.SyntaxThe syntax of the HOUR function is as … [Read more...]
Excel MINUTE Function – How To Use
The MINUTE function in Excel is categorized as a DATE/TIME function. It extracts the minute component from a time and generates an output that's always between 0–59. It's a simple function that relies on a serial number (i.e., an Excel-recognized time value), and returns the minutes from that value.SyntaxThe syntax of the MINUTE function is … [Read more...]
Excel MONTH Function – How To Use
The MONTH function is categorized as a Date/Time function in Excel and extracts the month component of a valid Excel date for us. The function returns an integer between 1 to 12. This return may be relayed to another function by nesting the MONTH function.SyntaxThe syntax of the MONTH function is as … [Read more...]
Excel YEAR Function – How To Use
The YEAR function in Excel is categorized as a Date/Time function. It extracts the year component from a valid, Excel recognized date and returns it as a four-digit value. For instance, when a cell contains the date 12/25/2001, the YEAR function returns 2001.The YEAR function is used by financial analysts for extracting the year component from … [Read more...]
Excel ERROR.TYPE Function – How To Use
The Excel ERROR.TYPE function returns a number that corresponds to an error type. As the name suggests, the function only works for errors. Upon finding anything other than errors, the function returns the #N/A (not available) error. When an error is found, the function returns an integer (error code) that tells you the type of error.But wait, … [Read more...]
Excel YEARFRAC Function – How to Use
The YEARFRAC function is categorized as a Date and Time function in Excel. It returns the difference between two supplied dates in terms of years. When the difference is fractional, the output will have a non-integer output, such as 3.5 years, for instance.Fractional years can save a lot of time for financial analysts projecting revenues or cash … [Read more...]
Excel WORKDAY Function – How to Use
The WORKDAY function is categorized as a Date and Time function. It helps us add or subtract N working days to a date provided by us.The formula has various possible use-cases. For instance, think of a wholesale business that has agreed to deliver orders from retailers within 10 working days. Instead of keeping track of overdue orders manually, … [Read more...]
Excel ISERROR Function – How To Use
The Excel ISERROR function checks whether a value is an error. The function only returns TRUE upon finding an error and returns FALSE for all other values.ISERROR, which literally means 'Is error?', tests all types of Excel errors. Making its entry into the Excel world in 2003, ISERROR comes from a group of IS functions that results in TRUE or … [Read more...]
