# How to Get nth day of year in excel?

To calculate the no. of day in a year from a particular date, we will use the DATE Function and YEAR Function. Here’s an example, to elaborate the steps that…

Continue readingTo calculate the no. of day in a year from a particular date, we will use the DATE Function and YEAR Function. Here’s an example, to elaborate the steps that…

Continue readingIf you want to count the cells in the range that do not contain errors, then we can use the SUMPRODUCT Function, NOT Function, and ISERR Function. Let’s take an…

Continue readingTo count the total characters, present in a particular cell, you can use the LEN Function. By characters we mean, anything present in the cell, be it the symbol, alphabet…

Continue readingIn this space, we will learn how to count data that ends with a particular value e.g. RSVPUP-12-P, here, P is the ending value of the cell. When you are…

Continue readingVLOOKUP is very handy When you have a particular data in hand, and you need to find something in relation to it, it becomes nearly impossible to look after it…

Continue readingWhen you are weak in math, even a cube root becomes a huge deal🙅! So, to find out the cube root🤓 of a number in excel, here’s what you can…

Continue readingIf you are looking for a way where you could convert feet and inches into inches through excel, you have come up in the right place. You see, when you…

Continue readingIf you want to find out the name from an email address, you have walked into the right place😏. To find the same, all you need is the LEFT Function and FIND Function.

Continue readingIf you have two timings⏳ in your screen and you want to calculate the difference between them or in other words you want to calculate the number of hours that…

Continue reading