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

How to Calculate years between dates in Excel

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

How to take Time difference in hours as decimal value in Excel

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

How to Count cells between dates in Excel

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

How to Add Months to a Date in Excel

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

How to Convert date to text in Excel

In this article, we will understand how to use Excel text function to convert Date to Text in Excel. Date & Text are different formats of Excel...

How to convert decimal Seconds into time format in Excel

In this article, we will learn about how to convert seconds (in decimal) to Seconds (in Time format). Excel Stores Time in General number format. S...

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.