IF with AND and IF with OR

The powerful function If can already do a lot of tricks, but we can for sure do more when we use it with AND or OR functions. Also, once we …

OFFSET+MATCH

One of the power of combining functions in one cell is using the best of these functions An example is here, OFFSET + MATCH will allow you to do something …

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 …

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 week number is in A5, …