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...
Macro Mondays – Delete All Rows That Contain A Specific Text String
Hello Excellers, time for some Excel Macro fun again. Today's Excel Macro tip is one I have been looking forward to sharing with you for a while. Are you looking for a quick way to delete all...
Formula Friday- Excel Tip- Generate Random Numbers With Excel.
Do you need to generate random numbers for a project? Excel can help. This guide will show you how to use the RAND and RANDBETWEEN functions to create random numbers in Excel. You can also learn some...
Macro Mondays – Limit The Scroll Area Or Range Movement In An Excel Worksheet
It's Macro Mondays time again. Have you ever been working on an Excel spreadsheet and had the scroll bar just go crazy, making it hard to navigate to the cells you need? Well, there is a way to...
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...