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

Category Archives for Formulas

Top 5 Methods to Remove First Character from a Cell in Excel

Yesterday, one of my colleagues, who is really passionate to learn Excel these days asked me this:“Do you know how to remove the first character from a cell in Excel?”I told him a small formula (which was easy) for that, but he was not satisfied and want another method.And after that, I told him about […]

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

➲ Continue Reading

Count Words in Excel [Cell + Range + Worksheet]

There is one option which I always wish Excel should have.That’s ==> Count Number of Words.If you work in Microsoft Word, there is an inbuilt option on the status bar which shows you how many words are there in the sheet.But, when it comes to Excel there is no such option to count words. You can […]

➲ Continue Reading
1 2 3 9