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

How to Find If a Day is a Holiday or Weekday in Excel

Many times while working in workflow management, as a team leader, manager or just as a student, you will get the need to know that if a given day is ...

How to add Decimal Hours to Time

As we know that the date and time in excel are nothing but numbers. These numbers are formatted in such a way that they tell the exact time and date. ...

How to Countdown Remaining Days in Excel

While working with date-based data, you often get the need to countdown the remaining days from one date to another date. In this article, we will...

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.