How to Add Years to a Date

If you want to add years to a date in excel, you can’t just simply do addition to add years. If you add year as number to a date it will actually ad...

How to Get Month From Date in Excel

Manytimes, we want to extract month from a date. Extracting them manually not a good idea. Excel provides special MONTH function to get month number f...

Excel TIME function

In this article, we will learn about how to use the TIME function in Excel. The TIME function returns the time in time format. It takes three inte...

Calculate years between dates

In this article, we will learn about how to get years between two dates using YEARFRAC function in Excel. The YEARFRAC function returns the number...

Time difference in hours as decimal value

In this article, we will learn about how to calculate the Time difference in hours as decimal values in Excel. In simple words, We need to get the...

Count cells between dates

In this article, we will learn about how to Count cells between dates using COUNTIFS in Excel. The COUNTIFS function gets the count dates that mee...

Add Months to a Date

In this article, we will learn how to add months and years to a date. To add any number of months to a start date we will use EDATE. Generic Formul...

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 Google PlusVisit Us On Youtube