## How to Get QUARTER from a Date in Excel

In Excel, there is no direct function to get a quarter from a date. But you can create a formula for this. Yes, you can use a formula to calculate a

## How to Calculate SQUARE ROOT in Excel + Insert Symbol

Excel is like a Swiss army knife for calculations. From mathematical to financial, it’s for every single thing you need to calculate. You can calculate simple to most complex things

## How to Remove First Character from a Cell in Excel

And after that, I told him about five different methods for this but then he got confused about which method is easy. Even I have created a small UDF to make it super easy for him to remove n number of characters from the start of a string.

## How to Calculate Time Difference Between Two Times in Excel

As you know, a time value is a numeric value which is formatted as a time but when you deduct one value from another it returns a decimal number and you need format it again as time […]

## How to Calculate Age in Excel using Date of Birth

Let’s say you are preparing a data where user’s age is one of the important things to capture. The thing is, if you ask every user to enter his/her age, chances are they can give you an approx number.

## How to Sum Values Between Two Dates using SUMIFS

Yes, you heard it right… …SUMIFS is the easiest and the best method to sum values between two dates… …(i.e. a range of dates). Let me tell you something.Let’s say, you are working