How to Create a Data Validation with Date Range

 Let say you need to create a data validation for dates in which you want to use a specific date range. In simple words, you want when a user enters a date in a cell that should be within a range of dates which you specify. Well, this can be done by using a custom formula based […]

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

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 the average of top 5 products. In short, you want to get the average of top 5 […]

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 […]