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

How to Determine Fiscal Quarter of Date in Excel

What is the Fiscal Quarter of Year? A Fiscal Quarter of year is 1/3 part of the financial year of a company. Suppose a company yearly period is Feb...

How to Calculate Quarter in Excel

Sometimes, we need to calculate the Quarter of the years of a specified date. For example, if the quarter of 1-jan-2020 is 1, the quarter of 2-Jul-201...

How to Add Business Days in Excel

So when you start a project or any work, you are asked to tell how many days it will take you to deliver. Let’s say you say 30 days. Then, what will...

How to Calculate Remaining Days of Month in Excel

Previously, we learned how to get number of days in a month using a given date. In this article, we will learn how to calculate remaining days in mo...

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.