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

## How to use SUMIF with Wildcard Characters in Excel

SUMIF is one of my favorite Excel functions and I’m sure it’s yours also.But one thing which I always worry about it, we can only sum values when criteria fully match

## How to Highlight Dates Between Two Dates

You have dates in column and you want to highlight all the dates which are between the range of two dates. Huh?OK, alright!Let’s say you have a start date 17-Jan-2017 and

## How to Get Day Name from a Date in Excel

Let’s say you have a date from that date you want to get the day name… i.e. Sat, Sunday. This can be done with a formula. In fact, there is more than

## How to Average TOP 5 Values in Excel

Let say you have a line-up of 20 products in your company and you have data for monthly sales of all the 20 products. From that data, you want to calculate

## How to Get Total Days in Month in Excel

Sometimes you need to calculate the total number of days in a month… …to use in the further calculation. It happens specifically when you work on templates and dashboards.Sometimes you need to