Basic attendance tracking: To track the records and calculate the overall attendance of a student, here’s what to do: As you can observe in the …
Continue Reading about How to create Attendance Tracking Formula? →
How to get same date next month using EDATE function?
When you are dealing with loads of data, and by mistakenly you make an error by writing all the dates of one month before it has to begin, this is …
Continue Reading about How to get same date next month using EDATE function? →
How to get Max Value ignoring errors in a range?
If you are dealing with loads of data and you need to know the maximum value in the range, but there many errors present in the range too. This is …
Continue Reading about How to get Max Value ignoring errors in a range? →
How to find missing values using IF formula?
When you are dealing with loads of data and you need to check for whether a particular value/ number/ product/ order is in the category or not, this …
Continue Reading about How to find missing values using IF formula? →
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 …
Continue Reading about How to Get nth day of year in excel? →
How to count cells without errors?
If 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 …