Learn with Manish Shori

  Summary The Excel NETWORKDAYS function calculates the number of working days between two dates. NETWORKDAYS automatically excludes weekends (Saturday and Sunday) and can optionally exclude a list of holidays. NETWORKDAYS includes both the start date and end date when calculating work days. This means if you give NETWORKDAYS the same date for start date and end date and the date is not a weekend or holiday, it will return 1. NETWORKDAYS can also optionally take into account holidays. For the holidays argument supply a range that contains holiday dates. These are also treated as non-working days and will not be included in the result. Purpose Get the number of working days between two dates. Return value A number representing days. Syntax =NETWORKDAYS (start_date, end_date, [holidays]) Arguments • start_date - The start date. • end_date - The end date. • holidays - [optional] A list of non-work days as dates. Count only days without holidays The result will be C

  Introduction Debit and Credit Notes are a part and parcel of daily transactions of any business. In simple words, when there are Sales Returns or Purchase Returns in a business, debit and credit notes are used. There is not a single business that does not have any kind of debit and credit notes. Concept of Debit & Credit Note The need for debit note and credit note arises most of the time when there is a Return of Goods. Usually when there is a return of goods, the person does not directly give the cash for the returned goods. He issues Credit Note if he is a seller and the buyer issues a Debit Note for the same transaction to the seller from whom he has received credit note. Example of Credit and Debit Note For a better understanding let us take a simple routine business transaction as an example. This is in simple terms is called sales returns entry in Tally or purchase returns entry in Tally. I SOLD goods worth ₹15,000 to Jugal. After checking the goods he did not li

Introduction Sweating is a bodily function that helps regulate your body temperature. sweating is the release of a salt-based fluid from your sweat glands. Sweating during warm weather is very common but if a person wakes up from bed soaked in sweat (even in a winter season) it is not a pleasant feeling. The most common areas of sweating on the body include: • armpits • face • palms of the hands • soles of the feet It does not allow for a sound sleep and may not always be related to warm weather. There is no serious underlying medical issue but it is always advisable to see a doctor. Sweating in normal amounts is an essential bodily process. Not enough sweating or too much sweating can both cause problems. The absence of sweat can be dangerous because your risk of overheating increases. Excessive sweating may be more psychologically damaging than physically damaging. Your body is equipped with an average of three million sweat glands. Sweating is normal and occurs regularly in

  Summary The Excel WORKDAY.INTL function takes a date and returns the nearest working in the future or past based on an offset value you provide. Unlike the WORKDAY function, WORKDAY.INTL allows you to customize which days are considered weekends (non-working days). You can use WORKDAY.INTL function to calculate completion dates, ship dates etc. that take into account non-working days. Purpose Get date n working days in future or past Return value Next or previous working date based on inputs Syntax =WORKDAY.INTL (start_date, days, [weekend], [holidays]) Arguments ·        start_date - The start date. ·        days - The end date. ·        weekend - [optional] Setting for which days of the week should be considered weekends. ·        holidays - [optional] A list of one or more dates that should be considered non-work days. Usage notes WORKDAY.INTL figures out a date that represents the "nearest" working day N days in the past or future. Use a posi

  In Tally what happens when you sell something but a customer returns the product or returns only a part of the product? That’s where you use credit notes and you can use easily create a credit note in Tally because there is a specific voucher in Tally just for that. In a similar way, let’s say you purchased a product and didn’t liked the product so you return the product. In this case, you will create a debit note in Tally. For example, you have put aside ₹10,000 for your monthly business or job expenses. But you are not sure whether it will be exactly ₹10,000 or ₹9,000 or more than ₹10,000. In this case, if you pass the accounting entry in Tally for ₹10,000, you will be creating a wrong entry and it will reflect wrongly in your accounts as well. So, here you can use memorandum voucher in Tally for passing these kinds of entries. Note: The main feature of memorandum vouchers is that it does not affect your accounts nor reflect on your Balance Sheet unless you convert it to a gener