Excel CHOOSE Function – How To Use

The CHOOSE function in MS Excel returns a value from a list of values based on an index number. The list of values can also be specified as cell references. Choose function can support up to 254 values.Although on its own CHOOSE function may not look much valuable, but when combined with other functions, it can work wonders. The function has … [Read more...]

How to Convert Text or Numbers To Dates in Excel

Let’s say you have an organization that makes hundreds of small transactions each day. You have several branches where the junior accountant punches in the numbers and dates into different software. It’s finally the end of the month, and you want to look at where you stand compared to the previous month.This will require that you draw a gazillion … [Read more...]

Excel IFS Function – How To Use

The IFS function in Excel is a logical function that, in simplest terms, applies multiple IF functions. It allows the users to test a value against multiple conditions. The function accepts one or more conditions (or Boolean expressions) and a value to be returned against each condition.The result returned by the function is the value that … [Read more...]

Excel DAYS Function – How To Use

The DAYS function, categorized as a Date/Time function, is a worksheet (WS) function that allows us to compute the number of days between any two given dates. The DAYS function saw the light of day with MS Excel 2013, so if you are on an older version, you will need to rely on the DATEDIF function instead.Syntax for the DAYS functionThe … [Read more...]

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...]