## 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 to help So, when A1 …

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 to help So, when A1 …

To do a search in a column or a row, MATCH is the function to look for It is very simple, you set the value to look for and where …

You must already know that when you press Enter after you modify a cell, the cell content will be saved and you jump down to cell below (we can change …

I don’t believe I don’t have this here yet. This is one of my oldest tricks When we have to do links between two workbooks (One cell in Workbook1 to …

I have been asked for a while now to just put a simple VLookup function, here it is, I know this might be stupid to post it here, but we …

Excel 2010 has a lot of new exciting things, one of them is the ‘Engineering’ category of functions, this was usually a plugin we have to add to get, but …

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 …

I need that more often than I thought It is basically extract the full workbook name that we are in, with no folders, and with no extension =MID(CELL(“filename”,A1),SEARCH(“[“,CELL(“filename”,A1))+1,SEARCH(“]”,CELL(“filename”,A1))-SEARCH(“[“,CELL(“filename”,A1))-6) So, here …