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