VLookup

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 …

CONVERT function

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 …

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 …

Extract current (Active) workbook name

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 …