Learn with Manish Shori

  Summary To calculate the number of workdays between two dates, you can use the NETWORKDAYS function.  Formula =NETWORKDAYS(start_date,end_date,holidays) Explanation To calculate the number of workdays between two dates, you can use the  NETWORKDAYS function. NETWORKDAYS automatically excludes weekends and it can optionally exclude a custom list of holidays as well. As in the above example start date is January 18, 2022 in cell A2 and end date is February 18, 2022 in cell B2 so the  formula will be: =NETWORKDAYS(A2,B2) And the result will be 24 Note: NETWORKDAYS includes both the start and end dates in the calculation if they are workdays. NETWORKDAYS can also exclude a custom list of holidays. For example, if you have holiday dates in C1:C10, you can tell NETWORKDAYS not to include these dates as workdays by adding that range as a third argument in the formula: =NETWORKDAYS(A2,B2,C1:C10) Custom weekends If you need take into account custom weekends (i.e...

  Introduction In order to run a business, we know that Sales are necessary but for selling we need to have something to sell. Here comes purchase entry. So, purchase things in a business is necessary and sell it at a higher price to earn profit. So, let’s see how we can create a purchase entry in Tally. Here is the exact step by step process. ·        From Gateway of Tally, go to Accounting Vouchers. ·        From there select Purchases from the right hand side bar or just simply press F9. ·        After selecting Purchases, we have to pass a Purchase Entry. As in this example I am purchasing goods worth ₹12,000 from Kartik. After you have perfectly written the entry as shown in the picture, press Enter to save it This is how you can easily create both the Sales Vouchers as well as the Purchase Vouchers in Tally. Now let’s see how it gets reflected in the Profit and Loss Account i...

  Summary The Excel NETWORKDAYS.INTL function calculates the number of working days between two dates. NETWORKDAYS.INTL excludes Saturday and Sunday by default but provides a way to specify which days of the week are considered weekends. The function can optionally exclude a list of holidays supplied as dates. Usage Get work days between two dates. Revert value A number representing days. Syntax =NETWORKDAYS.INTL (start_date, end_date, [weekend], [holidays]) Arguments ·        start_date - The start date ·        end_date - The end date ·        weekend - [optional] Setting for which days of the week should be considered weekends ·        holidays - [optional] A reference to dates that should be considered non-work days Usage notes NETWORKDAYS.INTL calculates work days between two dates. Work days exclude weekends (Saturday and Sunday b...

 Introduction  Creating Sales and Purchase vouchers in Tally is extremely easy and simple. They are often referred to as purchase entry in Tally and sales entry in Tally. Every business requires sales as well as purchases to operate and function. In Tally, creating sales and purchase vouchers is as simple as creating sales and purchase bills by hand. You have to follow the same process which you followed while writing bills by hand. Nothing new to do. It is just in a digital format. §   Sales Voucher as Accounting Invoice §   Purchase Voucher as Accounting Invoice The last thing I want to add before starting the explanation is that sales and purchase vouchers are 99% similar except that they are sales and purchase vouchers. Ledgers you need before Creating a Sales and a Purchase Voucher Before you create a sales or purchase voucher, you need to create 2 ledgers. They are: §   Sundry Debtor – The person to whom you are selling. §   Sundry Credi...

  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 ...