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 …