Learn with Manish Shori

  Excel DAYS Function Summary The Excel DAYS function returns the number of days between two dates. With a start  date in A1 and end date in B1 =DAYS(B1,A1) will return the days between the two  dates. Right click on the Result cell, where apply the formula, select Format Cell Click Format Cells to open the Dialog box and select Date from Custom Click OK. The number will change into date Purpose Get days between dates Return value A number representing days. Syntax =DAYS (end date, start date) Arguments ·        end date - The end date. ·        start date - The start date. Usage notes The DAYS function returns the number of days between two dates. =DAYS(A2,A1) Will return the same result as: =A2-A1 Unlike the simple formula above, the DAYS function can also handle dates in text  format as long as the date is recognized by Excel. For example: =DAYS("7/15/2016","7/1/2016") // returns 14 The DAYS function does not take into account a

  Delete the Voucher 1.   Open the Gateway of Tally 2.   Press D for Display 3.   Press A for Account Book 4.   Press P for open Purchase Register, if you created a purchase voucher otherwise press S for Sale Register or J for Journal Register. It is according to your wish which voucher you want to delete 5.   Select the month and enter. The window will look like this: 6.   Select the voucher. You can delete from here as click on the delete button at the bottom of the screen but it is recommended that first open the voucher, check it carefully then click on delete button at the bottom of the screen or press ALT+D for deletion. The screen appears: 7.   Press Y or enter for deletion or N for cancelation. 8.   The voucher is deleted.                       OR 1.   Open the Gateway of Tally 2.   Press D for Display 3.   Again press D for Day Book 4.   This will open the screen as looks: 5.   Select the voucher you want to delete. 6.   Press enter to open the voucher 7.   Click on

  Summary The Excel YEAR function returns the year component of a date as a 4-digit number. You can use the YEAR function to extract a year number from a date into a cell or to extract and feed a year value into another formula like the DATE function. Purpose Get the year from a date Return value Year as 4-digit number Syntax =YEAR (date) The result will be Arguments date - A valid Excel date. Usage notes The YEAR function extracts the year from a given date as a 4-digit number. For example: =YEAR("23-Aug-2021") // returns 2021 =YEAR("11-May-2019") // returns 2019 You can use the YEAR function to extract a month number from a date into a cell or to feed a month number into another function like the DATE function: =DATE(YEAR(A1),1,1) // first of same year The result will be Notes • Date must be a valid Excel date. • YEAR will return a #VALUE error on text values  Recommended Articles what is Tally Gateway of Tally Take care of Security

  Introduction Inventory management is one of the toughest business activities for small and growing businesses. Not only do you need to physically care for the stuff but you also have to make sure that you don’t run out of some items or have too much of some other items. Tally provides outstanding features that make inventory management a lot easy. With not too much effort, you can get your inventory management system up and running. As you record sales and purchases, Tally will keep track of your inventory.In this Tally Tutorials, you’ll learn how to maintain inventory in Tally using inventory masters such as stock categories, stock groups and stock items. Let’s start.. Gateway of Tally, press ALA: Select the ledger which was used in the voucher and alter the voucher from the list. In a similar way, you can see all the vouchers which you have passed in Tally. Instead of ALA, press ALD: and then select the ledger for which you want to see the vouchers. Inventory Vouchers or Manufact

  Summary The IF function can perform a logical test and return one value for a TRUE result and another for a FALSE result. For example, to "pass" scores more than or equal to 70: =IF(C2>=70,"Pass","Fail") More than one condition can be tested by nesting IF functions. The IF function can be combined with logical functions like AND and OR. Purpose Test for a specific condition Return value The values you supply for TRUE or FALSE Syntax =IF (logical_test, [value_if_true], [value_if_false]) Arguments ·         logical_test - A value or logical expression that can be evaluated as TRUE or FALSE. ·         value_if_true - [optional] The value to return when logical_test evaluates to TRUE. ·         value_if_false - [optional] The value to return when logical_test evaluates to FALSE. Usage notes Use the IF function to test for or evaluate certain conditions and then react differently depending on whether the test was TRUE or FALSE.