Excel DAY Function – How To Use

The DAY function has a simple purpose when used by itself. It gives you the "day" component (i.e., a number from 1-31) of a date inside a cell. However, the DAY function allows us to play around with dates in our worksheets by using it with some logical arguments or other functions, as will see in the examples section.But first, let's get some … [Read more...]

How To Add Days, Months & Years to Dates and Time in Excel

Today, I am going to equip you with a few formulas that will enable you to add Dates and Times in your Excel worksheet.These are particularly useful for financial analysts because it helps them play around with and manipulate time periods in their financial models. For example, while projecting cash flows, you may want to project them monthly, … [Read more...]

How to Concatenate in Excel – The Ultimate Guide

Often the data in your spreadsheets is not according to your needs, so you may need to replace some strings, split some text, merge cells or concatenate data to format the data as per your needs.In this tutorial, we are going to learn different ways to concatenate cells, columns, and ranges in excel. So, without further ado, let’s dive right … [Read more...]

How to Subtract Dates and Times in Excel

In the last article, we worked with the DATVALUE function to convert dates from text to a serial number. Now let’s take things up a notch and look at some formulas that will enable us to manipulate dates and times in a worksheet.In this tutorial, we will try to understand how to subtract dates in Excel and calculate the difference between dates … [Read more...]

Excel DATEVALUE Function – How To Use

The DATEVALUE function serves a simple purpose. It converts a date written as a text string into a serial number that Excel can recognize. While it looks (and indeed is) pretty straightforward, the DATEVALUE function provides powerful ammunition for converting dates, which consequently enables us to manipulate them with formulas and pivot … [Read more...]

Excel DATE Function – How To Use

The DATE function is a financial analyst's best pal and categorized as a Date/Time function in Excel. The criticality of the DATE function's role is sourced from Excel's reluctance to keep the day, month, and year as a date. Instead, Excel stores them as a serial number.Directly handing over dates as a text string may not work well for all Excel … [Read more...]

Excel FILTER Function – How To Use

The FILTER function is an Excel function that lets you fetch or "filter" a data set based on the criteria supplied via an argument. The FILTER function was introduced in Office 365 and will not be accessible in Office 2019 or earlier versions.FILTER is an in-built worksheet function and belongs to Excel's new Dynamic Arrays function category. The … [Read more...]

Excel IFERROR Function – How To Use

IFERROR function provides a great way to handle errors in Excel formulas. Excel IFERROR function returns a custom result (which can be a text, cell reference, or another formula) when the expression enclosed inside it returns an error.IFERROR helps you catch and address problems with your formulas so you can have clean and orderly spreadsheets. … [Read more...]