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

Adding Current Date and Time Stamp in Excel

Sometimes it happens that you might want to enter the current date and time stamp in your excel spreadsheets automatically. This need usually arrives because of various reasons, in my case I was urged to find a solution to it as I need to do some team management wherein I required the time my associates are spending on work daily. So, in this case … [Read more...]

NETWORKDAYS Function In Excel

The best thing about Excel is that it gives us a wide variety of options to choose from its functions based on our needs. And today, we are going to have a look at a similar function, i.e. NETWORKDAYS. Using this function in excel you can easily calculate the number of weekdays between two dates.As the name suggests, NETWORKDAYS Function in Excel … [Read more...]

Excel DATEDIF Function – Calculate Difference Between Two Dates

DATEDIF is a hidden function in Excel. As the name suggests the job of this function is to calculate the difference between two given dates.I have referred to this function as hidden because for some reason Microsoft has decided not to document this function. And because of this, you won’t find this function in the Formula Tab.To verify this, … [Read more...]