WeChat-Image_20210412111831

How To Count The Number Of Weekends/Weekdays Between Two Dates In Excel?

Sometimes, we need to know how many specific weekdays between two dates. For example, I have two dates: the start date is 1/1/2014 and the end date is 2/15/2014, now I want to know how many times a Sunday or a Monday or a Tuesday etc occurs in this duration. Maybe this is somewhat difficult […]

WeChat-Image_20210412111831

Understand Power BI Workspace Roles: Viewer / Contributor / Member / Admin

In this blog you will understand the difference between Power BI workspace roles. In Power BI new workspace we have four roles and they are- Admin, Member, Contributor & Viewer. Let’s understand all in detail- Admin Create, edit, delete, copy and publish reports and content in a workspace. Publish, Update, or Share App in workspace. […]

WeChat-Image_20210412111831

Excel VBA – How to Turn Automatic Calculations Off (or On)

Whenever you update a cell, Excel goes through a process to recalculate the workbook. When working directly within Excel you want this to happen 99.9% of the time (the exception being if you are working with an extremely large workbook). However, this can really slow down your VBA code. It’s a good practice to set […]

WeChat-Image_20210412111831

How to Prevent Excel From Auto Calculating and Updating Data in Your Workbook?

Sometimes you will see the information that asks you whether you want to save the changes or not. But actually you make no change to the file. Why does this information still appear? If you make some modifications to an Excel file and then close it without saving, it will ask you whether you want […]

WeChat-Image_20210412111831

Extract Numbers From a String in Excel (Using Formulas or VBA)

By Sumit Bansal There is no inbuilt function in Excel to extract the numbers from a string in a cell (or vice versa –  remove the numeric part and extract the text part from an alphanumeric string). However, this can be done using a cocktail of Excel functions or some simple VBA code. Let me first show you what […]

WeChat-Image_20210412111831

How to Find the Earliest and Latest Date in Excel

We have a range of dates and we want to look up the earliest and the latest date based on certain criteria like the earliest date for a showing movie, we can use MIN and MAX functions with IF function or INDEX function together to find the matched date based on some criteria. Except using formula, we can also use […]