How to Activate a Sheet using VBA

Let’s say you are working with multiple worksheets, and for you, it’s hard to navigate to a sheet using tab.In this situation, you can use a VBA code to activate any worksheet. And, to write a VBA code for this you need to use Worksheet.Activate Method.In this post, I’d like to share with you a simple […]

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 one formula can be used.Get Day Name With TEXT FunctionYou can use TEXT function for extracting day name from a date. Let’s say you […]

How to Average TOP 5 Values in Excel

Let say you have a line-up of 20 products in your company.Now you have data for monthly sales of all the 20 products and from that data, you want to calculate the average of top 5 products.In short, you want to get the average of top 5 values from that data.Formula: Average TOP 5 ValuesTo […]

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. So today, let me show a simple formula which can do this for you.To calculate the number of days in a given month from a date, we […]

6 Methods to Convert a Formula to Value in Excel

From the starting days of my job, I have learned one thing hard way that before sending a report to someone we must convert a formula to value.It simply means to replace a formula with its result.Just think this way, when you send a report to someone, they are not concerned with formulas but result.Why […]