learn excel

In a previous post, I showed you how to use the NETWORKDAYS() function in Excel to calculate the number of work days between two dates in Excel. In today’s post we’ll take a look at how you can use further Excel functions to calculate number of days between two dates in Excel. … [Read more...] about How to Calculate Number of Days Between Two Dates in Excel

There is no straightforward way to enter a string of text in Excel along with a date or time. Excel simply does not allow you to combine text and dates or text and time together in the same cell. However, there is a simple workaround that makes it possible for you to do this. In … [Read more...] about How to Combine Text with a Date or Time in Excel

There may be times when you want to share or view some data in an Excel worksheet, but not all of its contents. In such cases, you can hide the data from view. In this Excel tutorial, I’ll show you two ways in which to hide data in a worksheet in Excel 2016. … [Read more...] about How to Hide Data in a Worksheet in Excel

If you’re working with a lot of employee data and need to create an maintain a database with the employee’s ages, automatically updated every year, you can make use the the functions in Excel to do it. For this purpose all you need is the year of their birth or their date of … [Read more...] about How to Calculate the Age of a Person in Excel

Got a series of dates in Excel and want to know how to get the name of a days they fall on? Here’s a quick Excel guide to help you with that using a simple formula with some variations. Here's how to get the name of a day from a date. … [Read more...] about How to Get the Name of a Day from a Date in Excel

If you use Excel to calculate payment schedules in Excel, one of the most important calculations you do will involve computation of dats between dates. For this purpose you may want to exclude weekends, holidays and other specific days. Thankfully there’s a really useful function … [Read more...] about How to Calculate the Number of Work Days Between Two Dates in Excel

If you are someone who does a lot of Excel work, you probably have found yourself in a situation where you had to convert time to minutes or minutes to a time format. For instance, you may have wanted to change 3:45 to 180 minutes or convert 225 minutes to hours and minutes … [Read more...] about How to Convert Time to Minutes in Excel