How to use the WORKDAY.INTL function in Excel

  In this article, we will learn How to use the WORKDAY.INTL function in Excel. How does WORKDAY function in excel actually work? As...

How to use the NETWORKDAYS.INTL function in Excel

In this article, we will learn How to use the NETWORKDAYS.INTL function in Excel. What are working and non working days ? Usually Saturdays ...

How to Convert String To Excel Datetime

It is common to import data from other sources in Excel and it is also common to not get properly formatted data. For example, most of the time wh...

How to round of time values in Excel

In this article, we will learn How to round time values in Excel. Scenario: We like to work on well maintained data. So cleaning and brushin...

How to join dates to get date range in Excel

In this article, we will learn How to join dates to get a date range in Excel. Scenario: At Instance, we need to get the date values as date...

How to use the DATE function in Excel

The Excel DATE function is a DATE & TIME function. This function returns the DATE value in numerical format. Convert the output to date format...

How to Count Dates of Current Month in Excel Range

Let's say you have to manage meeting dates in an Excel file. Now you want to how many dates (meetings) are there in the current month, next month ...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube