Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.

Worth $20, Absolutely Free

All posts by Puneet

How to Extract Hyperlink Address (URL) in Excel Using VBA UDF

Let’s say you got an Excel workbook from your colleague where you have a list of hyperlinks in a column.Now from this list, you want to extract all the hyperlink URL addresses.The manual method is a real pain, you need to copy-paste each URL one by one.So the better way is to create a UDF […]

➲ Continue Reading

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 an end date 19-Mar-2017, and from the dates column, you want to highlight all the cells in which date is between these two dates.For this, […]

➲ Continue Reading

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

➲ Continue Reading

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

➲ Continue Reading

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

➲ Continue Reading
1 2 3 27