Microsoft Excel Tutorials
When you have a bunch of dates and all you need is to get the month out of it, here’s what you can do: As you can see in the image above, we have a couple of dates😂LOL!!! And we need to find the …
Continue Reading about Get Month from date Using MONTH Formula →
Understand and fix 6 common excel errors you're tired of seeing while working on your worksheet. These excel errors are ####, #NAME?, #DIV/0!, #NULL!, #REF!, #VALUE!. Learn: [Fixed] Excel Error …
Continue Reading about Fix 6 Common Excel Errors You’re Tired of seeing →
To get the domain from the email address we will use the RIGHT Function, LEN Function, and FIND Function. Let’s get started: As you can see in the image above, we have taken email address. …
Continue Reading about How to get the domain from email address? →
Today We Will Discuss By Using Power Query Add A Row Index to A Loaded Query What is Power Query? Power Query is a data connection technology. Power Query has been renamed and in excel 2016 it …
Continue Reading about How To Add A Row Index to A Loaded Query →
MONTH Formula in Excel What is the month formula in Excel? It provides the month from a date with a simple formula. The formula is written below: =MONTH(serial_number) It means; =MONTH …
Continue Reading about How to get Month number from a date With A MONTH Formula →
