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...]
Excel WEEKDAY Function – How to Use
The WEEKDAY function is a DATE and TIME function that can be used to find the weekday for a given date. The date is supplied to the function as an argument, and consequently, the function returns an integer between 1 – 7, each number representing a day of the week. By default, 1 represents Sunday and 7 represents Saturday, but these values are … [Read more...]
How to Calculate Age in Excel (7 Easy Formulas)
Excel doesn't have a dedicated function for calculating age, but there are several ways we can use someone's date of birth to compute the person's age. We won't just learn how to compute someone's age in years, we'll even boil their age down to months and days.There are several formulas, as well as combinations of formulas, that we can use to … [Read more...]
Excel ISERR Function – How to Use
The Excel ISERR function checks whether a value is an error (except for the #N/A error) or not. The function returns TRUE upon finding any error except the #N/A. It returns FALSE for all other values and for #N/A errors.ISERR literally means ‘Is error?’, but by shortening the spelling, it hints that it would not work for #N/A errors. This may … [Read more...]
Excel ISNA Function – How To Use
The Excel ISNA function checks whether a value is #N/A or not. The function only returns TRUE upon finding the #N/A error. It returns FALSE for all other values or errors. The objective of the ISNA function is to solely recognize and handle #N/A errors and return TRUE when an #N/A error is found and FALSE for everything else.By #N/A here, we mean … [Read more...]
