Hello Excellers, welcome to another #formulafriday blog post in my #ExcelTips series. Excel has a wide range of features, and the formula bar is one of the most important of...
Tag: Formula
Hi Excellers, this is a different #formulafriday in my Excel 2020 series. I want to share with you 3 ways to protect your Excel formulas. So, you have spent a long time preparing your Excel...
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 – How To Use The DAY Function In Excel With Examples.
Happy Friday Excellers time for more #formulafriday fun. Today let's look at using the DAY() function. In Excel, the DAY function calculates the day of the month for a given date. This function is...
Hey All, it's Formula Friday again. Today let's look at a handy little formula called DATEDIF. DATEDIF is a function in Excel that calculates the difference between two dates. It can be used to...
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...