Formula Friday – Find The Date Of The Fourth Business Day Of The Next Month.
Do you find yourself trying to figure out the date of the a specific business day of a future month? If so, you’re not alone. It’s a question that can stump even the most experienced Excel users...
Formula Friday – Two Ways To Highlight Today’s Date In Your Excel Dataset
Hello, Excellers. Welcome to another instalment of #formulafriday. Today let's look at here a handy Excel Tip if you want to highlight today's date in your Excel data set. I have...
Formula Friday – Randomly generate words in Excel with INDEX and RANDBETWEEN.
Are you looking for an easy way to randomly generate words in Excel? If so, you’re in luck! Using a combination of the INDEX and RANDBETWEEN functions together with some creative data entry...
Hello Excellers and welcome back to another blog post in my series of #FormulaFiday #ExcelTips. Today, let's answer an Excel question from one of my subscribers. They want to be able to delete...
Formula Friday – Find And Hide All Formulas On An Excel Worksheet
Happy Formula Friday, Excellers. Formulas are a huge part of Excel, and they can be very helpful in organizing and analyzing data. However, sometimes you may need to hide them from view so that your...
Formula Friday – Why is my formula showing in a cell and not the result??
Hello Excellers. Welcome to another blog post article in my #Excel series. When you create a formula in Excel, you may expect to see the result of that formula immediately show up in the cell where...