Calculate hours between two cells
We needed that several times in the past Then I found it in an old file in my laptop, thought to share it for others...
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...
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...
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...
Convert 2-column into wide (column-row) table
This Excel file will convert a table of two columns into a Column-Row table Using functions only and auto-updated once the Main table update In...
Multiple-Validations (connected to each other)
Here is the free file for a special request by a client He wanted to have multiple cells having Data – Validation to same list...
Insert Blank rows into table using functions
Here you will see how to work with functions to insert a blank row every certain number of rows in a table using a blank...