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
excel how to
How to Calculate the Number of Work Days Between Two Dates 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
How to Convert Time to Minutes 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
How to Create a Custom List in Excel
In this Excel tutorial, we’ll show you how to create a custom list in Excel and save it so you don;t have to manually add one to your worksheets every time the need arises. By default, Excel offers some common custom lists like days of the week and months of the year. If you … [Read more...] about How to Create a Custom List in Excel
Learn Excel: How to Use the Excel Count Function
When you work with large sets of data in Excel, one of the most common analysis you do involves counting cells in the worksheet. The Excel Count function makes it easy for you to count cells based on various criteria. In our Learn Excel Series, we'll be taking a look at the … [Read more...] about Learn Excel: How to Use the Excel Count Function