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

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 use the YEARFRAC Function in Excel

In this article, we will learn about how to use the YEARFRAC function in Excel. YEARFRAC function calculates the fraction of year between the start...

How to use the EOMONTH Function in Excel

In this article, we will learn about how to get the excel last day of the month. At times, we need to know the expiry date of any product given its p...

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