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...
Excel Tip- Formula Friday -How To Create a drop down list for your hyperlinks in Excel
Adding a drop down list to your Excel sheet is a really great and convenient way to allow data entry to your Excel worksheets whilst maintaining good quality consistent data and reducing the amount...
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 #FormulaFriday #Excel blog post in my Excel series. Today I want to answer a question that a subscriber sent to me. If you want to ask any...
Formula Friday – 3 Reasons To Use Named Ranges In Your Excel Formulas
Hey Excellers, thanks for joining me for another #formulafriday. Today I want to share my top 3 reasons to use named ranges in your formulas. There are many benefits to using named ranges in your...
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...