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 – Let’s Use TEXTJOIN To Join Text Strings Without The CONCATENATE Complexity
Happy Friday Excellers. Welcome back to another #FormulaFriday #Excel blog post in my Excel series. I will compare TEXTJOIN and CONCATENATE. If you have Excel 2016 then you may be...
Hello Excellers and welcome back to another blog post in my Excel tips #Excel #FormulaFriday blog post in my Excel series. A lot of systems (mainframe usually) use Julian dates. This blogpost will...
Hello Excellers, and welcome back to another #FormulaFriday #Excel formula tip in my Excel Series. Today, I want to show you how to use the FORMULATEXT function to check if your cells contain the...
Hello, time for more #formulafriday fun with Excel Formulas. Do you ever need to update multiple Excel formulas in Excel? If so, you'll be happy to know that there is an easy way to do this. In...
Formula Friday – How To Make An Exact Copy OF An Excel Formula
Hello it is #formulafriday again, today let's look at how to make an EXACT copy of an Excel Formula. So, if you ever needed to make an exact copy of an Excel formula it can be a bit tricky. Or,...