IF with AND and IF with OR

The powerful function If can already do a lot of tricks, but we can for sure do more when we use it with AND or OR functions. Also, once we …

New function IFERROR, finally

We have already gotten used to use VLOOKUP, MATCH and other functions that generates errors inside an IF But, we do not need that anymore We can use the new …

Workdays – Across months

Get total number of days per month This was a question from one of my friends, This set of formulas will calculate how many days (Networkdays) in each of the …

Week number to Month number

Now we need to convert week number to month number This is exactly the same as week number to date (reverse weeknum) So, when the week number is in A5, …

iframe in Excel (XLiFrame)

This is the iframe in Excel, if you are familiar with the HTML concept of iframe, you will understand this one right away, it is basically the same project as …