ExcelDemy | Free Excel Tutorial & Online Courses

How to Use WEEKDAY Function in Excel ( With 8 Examples)

Aug 2, 2021 Excel Formulas

The WEEKDAY function is especially handy for planning, scheduling, and even financial analysis. It is classified as a Date and Time function in Excel ...

How to Use the NOW Function in Excel (8 Suitable Examples)

Aug 2, 2021 Uncategorized

In Microsoft Excel, the NOW function is used to show timestamps. By enclosing the NOW function inside other related functions, different useful ...

Excel NETWORKDAYS.INTL Function with Formula

Aug 2, 2021 Excel Formulas

Today I will be showing how you can calculate the total number of workdays between two dates using the NETWORKDAYS.INTL function of Excel. ...

Excel TODAY Function (6 Easy Examples)

Aug 2, 2021 Excel Formulas

The TODAY function is beneficial when we require to have the current date illustrated on a worksheet instead of opening the workbook. It is also ...

Excel SECOND Function

Aug 2, 2021 Excel Functions

Excel provides various functions to maximize and speed up your productivity. Today we are going to show you how to use the SECOND function. For the ...

How to Use MINUTE Function in Excel (6 Examples)

Aug 1, 2021 Excel Formulas

The MINUTE in Excel is a built-in function that is classified as a Date/Time function. It can be found on the Formulas tab of the Ribbon. In this ...

Excel DATE Function with Formulas (Both Array and Non-Array)

Aug 2, 2021 Excel Formulas

Today I will be showing how you can use the DATE function of Excel. Download Practice Workbook Excel DATE Function with Formulas (Both Array and ...

Excel DAY Function

Aug 1, 2021 Excel Functions

Excel provides several functions to maximize and speed up your productivity. Today we are going to show you the usage of the DAY function. For ...

Excel HOUR Function (With 5 Easy Examples)

Aug 1, 2021 Excel Formulas

Excel’s HOUR function is classified under two Excel functions which are DATE and TIME. It is one of the most popular functions in Excel in terms of ...

How to Use NETWORKDAYS Function in Excel (3 Suitable Examples)

Aug 1, 2021 Excel Functions

In Microsoft Excel, the NETWORKDAYS function is used to count the number of dates between two specific dates. In this article, you’ll get to learn ...

How to Use DATEVALUE Function in Excel (6 Suitable Examples)

Aug 1, 2021 Excel Functions

DATEVALUE function in Microsoft Excel is generally used to convert a text date into the date-time number codes. In this article, you’ll get to learn ...

Dynamic Advanced Filter Excel (VBA & Macro)

Aug 1, 2021 Macros & Excel VBA

Circumstances may demand different types of filter operations; advanced, dynamic, and so on. Our agenda for today is to show you how to use the ...

Fix Excel Date Not Formatting Correctly (8 Quick Solutions)

Aug 1, 2021 Excel Formulas

In data entry, it’s a common phenomenon that the dates get manipulated with text or other formats. In this article, you’ll learn how you can change, ...

Advanced Filter with Multiple Criteria in Excel(15 Suitable Examples)

Aug 1, 2021 Data Analysis with Excel

In Microsoft Excel, using Advanced Filter with multiple criteria allows us to add different logics and functions to execute a wide range of ...

How to Sort Data in Excel Using Formula

Jul 31, 2021 Excel Formulas

Today I will be showing how you can sort any data using certain formulas in Excel. Download Practice Workbook How to Sort Data in Excel Using ...

Latest Posts