In this post we will see how we can calculate total number of years, months and days between two dates.
For example: If the start date is 2 October 2021 and end date is 3 November 2022 then we should get 1year 1month 1day.
DATEDIF - Formula DATEDIF(start_date, end_date,“Y”) => Provides total number of years between starts and end date. In above example, the total number of yeats between the dates is one year.
In this post, i will share an Excel tutorial where you can create tables and calculate the total amount spent by each person and find out who owes or need to give to whom.
At the end of this post you will be able to make something similar to the following table below.
Table1 = List of expenses including name and amount as well as the grand total spent by all.
In this post, i will be sharing some commonly used excel formulas to make your life easier while creating report.
Find cost in Table 2 by matching Serial Number in Table 1 If you have to find the corresponding value of some data in a table from another table then you can combine the INDEX and MATCH as follows:
=INDEX(Table1[Cost],MATCH([@[Serial Number]],Table1[Serial Number],0),0) Check if serial number in Table B exists in Table A Using combination of ISNA and VLOOKUP to check if the serial number in table b exists in table A.