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

➲ Continue ReadingLet 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 […]

➲ Continue ReadingSometimes 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 […]

➲ Continue ReadingFrom 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 […]

➲ Continue ReadingIt happens sometimes you send Excel files to others and they made some changes into formulasOr, sometimes you simply don’t want to show a formula to others.Hiding a formula is a simple way to do this so that others can’t able to see which formula you have used and how they get calculated.Now the question […]

➲ Continue Reading