When you are dealing with the sales💰 of the products and the upper management asks🤔 for the details of the product which has gained the least sales in …
Continue Reading about How to Lookup lowest value in table? →
How to get the next Working Day?
If you want to calculate the next working day, you have come to the right place! Let’s take an example and evaluate the procedure of the …
How to get Number of Days in Month?
If you have a bunch of dates and you want to know the number of days in month or particular month in your datasheet, here’s what you can …
Continue Reading about How to get Number of Days in Month? →
How to calculate Annuity Interest rate?
Before we begin, let’s talk about annuity. Annuity is a particular amount given to a person for a particular time being or at times, for the rest …
Continue Reading about How to calculate Annuity Interest rate? →
How to create Attendance Tracking Formula?
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? →