How to get quarter of year from date

In this article, we will learn to generate random text values in  Excel. For this article we will be needing the use the following functions: ...

Working With Date and Time in Excel

Date and time in excel are treated a bit differently in excel than in other spreadsheets software. If you don't know how Excel date and time work, you...

How to use the DATEVALUE Function in Excel

In this article,  we will learn how to use the DATEVALUE function in excel. DATEVALUE function & TIMEVALUE function in excel are very useful fun...

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

How to Add Years to a Date

If you want to add years to a date in excel, you can’t just simply do an addition to add years. If you add 1 year as a number to a date, it wil add ...

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

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