Category: Standard functions

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...

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...

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...

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...

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...

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...

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...