Get 3rd Wednesday of month
This was an interesting request. Needing to get the date of 3rd Wednesday for a given month, automatically, using pure Excel functions. So, sharing here on what is the formula …
This was an interesting request. Needing to get the date of 3rd Wednesday for a given month, automatically, using pure Excel functions. So, sharing here on what is the formula …
This one is similar to http://xlfxs.com/sort-list-using-functions/ where we use some controls here that make it more user-friendly.
If you are like me, then you must have needed to use CHOOSE functionThis is basically like “SELECT CASE” statement, but more limited So, in few words, you can derive …