Finding the Last Day of a Given Month in Excel

While preparing tax reports, you may be required to find out the last day of a given month. Excel has a very useful built in function called EOMONT...

Separating Dates and Times in Microsoft Excel

In this article, you’ll learn how to separate dates and time from a cell you need to use the INT & MOD formulae in Microsoft Excel. For data an...

How to Calculate the Quarter in Microsoft Excel

In this article we will learn how to calculate the quarter number for Fiscal Year and Calendar Year  in  Microsoft Excel. To calculate quarter in E...

Calculating Number of Days, Weeks, Months and Years between Dates in Microsoft Excel

In this article you’ll learn, how to calculate number of days, weeks, months and years between 2 dates in Microsoft Excel. To calculate the same, w...

DAYS function

DAYS function is introduced in Excel 2013 and it is very useful function to calculate the number of days between two dates. Syntax:- = DAYS(end_...

Avoiding Errors When Counting Date Values That Meet Specified Criteria

Problem: The range A2:B9 contains a series of dates and the corresponding number of hours worked on each of them. An empty cell in column B that m...

Counting the Number of Values Between Upper and Lower Limits

Problem: Finding the number of values in List1 (Column A) that are larger than 20 and smaller than 50. Solution: Use the COUNTIF function as ...

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