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.
10000+ Copies Already Downloaded
DatedIF function is the best tool to calculate your age from date of birth. Ahead In this post, I will show you how to use the DatedIF function in excel, why it is a useful & worth to learn. Use of DatedIF DATEDIF Function In Excel will be your buddy if you want to calculate the […]Check it out now
We have already learned in Basic Date Functions that dates are the base of all the data & trend analysis. But, sometimes it is very nasty when we got some dates in a non-standard format. In these conditions, we have to correct date format by using some formulas and functions. Using formulas doesn’t mean that […]Check it out now
To convert a normal text into a Sentence Case In Excel using a single formula is not possible unless you write a UDF. We have text formulas to convert a normal text into upper case, lower case & proper case. But not a particular function for Sentence Case. But, good news is that we can use these formulas for converting a normal text string […]Check it out now