Excel Formula.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Excel Formulas													SUBSTITUTE
2	EmployeeID	First Name	Last Name	Age	Gender	Job Title	Salary	Start Date	End Date	Text1(H2,"dd/mm/yyyy")	Text2(H2,"dd/mm/yyyyy")	CONCATENATE	CONCATENATE	1 instance	2 instance	No instance
3	1001	Parl	Harbor	30	Female	Assistant	35000	2002/03/5	7/5/2012	07/05/2012	05/03/2002	Parl Harbor	Parl.Harbor@gmail.com	07-05/2012	07/05-2012	07-05-2012
4	1002	Jim	Addem	28	Male	Salesman	50000	3/4/1998	2/10/2017	02/10/2017	03/04/1998	Jim Addem	Jim .Addem@gmail.com	02-10/2017	02/10-2017	02-10-2017
5	1003	Osli	Beasley	25	Female	Accountant	54000	8/5/2000	4/6/2016	04/06/2016	08/05/2000	Osli Beasley	Osli.Beasley@gmail.com	04-06/2016	04/06-2016	04-06-2016
6	1004	Kevin	Palmer	35	Male	HR	60000	6/5/2001	3/6/2010	03/06/2010	06/05/2001	Kevin Palmer	Kevin.Palmer@gmail.com	03-06/2010	03/06-2010	03-06-2010
7	1005	Stanley	Hudson	49	Female	Salesman	43000	2/11/2002	12/7/2009	12/07/2009	02/11/2002	Stanley Hudson	Stanley.Hudson@gmail.com	12-07/2009	12/07-2009	12-07-2009
8	1006	Tony	Stark	37	Male	Manager	49000	3/6/2003	3/6/2015	03/06/2015	03/06/2003	Tony Stark	Tony.Stark@gmail.com	03-06/2015	03/06-2015	03-06-2015
9	1007	Harvard	Hawk	50	Male	Manager	40000	9/3/2012	9/8/2016	09/08/2016	09/03/2012	Harvard Hawk	Harvard.Hawk@gmail.com	09-08/2016	09/08-2016	09-08-2016
10	1008	Angela	Martin	32	Female	Receptionist	32000	6/7/2008	3/6/2014	03/06/2014	06/07/2008	Angela Martin	Angela.Martin@gmail.com	03-06/2014	03/06-2014	03-06-2014
11	1009	Robbin	Sharma	60	Male	Accountant	44000	5/1/1998	3/1/2016	03/01/2016	05/01/1998	Robbin Sharma	Robbin.Sharma@gmail.com	03-01/2016	03/01-2016	03-01-2016
12	1010	Toby	Robbin	43	Male	HR	50000	5/5/2005	2/8/2015	02/08/2015	05/05/2005	Toby Robbin	Toby.Robbin@gmail.com	02-08/2015	02/08-2015	02-08-2015
13
14
15
16	SUM	COUNT	Mininum	LENS OF Last Name	LEFT	RIGHT	Trim	Days	NetworkDays
17	457000	10	32000	6	Parl	2012	Harbor	3662	2655
18	SUMIF	COUNTIF	Maximum	5	Jim	2017	Addem	7019	5087
19	114000	5	60000	9	Osli	2016	Beasley	5786	4195
20	SUMIFS	COUNTIFS		6	Kevi	2010	Palmer	3267	2369
21	75000	4		6	Stan	2009	Hudson	2410	1745
22				7	Tony	2015	Stark	4320	3132
23				4	Harv	2016	Hawk	1590	1153
24				10	Ange	2014	Martin	2127	1542
25				6	Robb	2016	Sharma	6478	4695
26				6	Toby	2015	Robbin	3687	2672
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100