STATIC DATA DAY
6/25/2025 Ctrl + ; 8/28/2024 28
18:20 Ctrl + Shift + ;
DYNAMIC TEXT Functions for Dates
#NAME?
DATA HOUR
04:45:25 PM 16
hh
mm
ss
MONTH YEAR DATE START DATE 1/1/2020
8 2024 8/28/2024 END DATE 7/13/2025
DAY DIFF. Subtract
DAYS
DATEDIF d
DATEDIF m
DATEDIF y
DATEDIF ym
DATEDIF md
DATEDIF yd
8/28/2024 Weekday
Weeknum
YearFrac
MINUTE SECOND TIME
45 25 01:45:16 AM
START DATE 1/1/2024
END DATE 12/31/2024
2020 Net Working Networkdays 262
2020 252
2020 Networkdays.Intl 301
66
5
6
12
193
35
5.53333333333333
Holidays START DATE 1/1/2024
1/1/2024 NO. OF DAYS 100
1/15/2024
1/26/2024 Workday Workday
4/9/2024
4/11/2024 Workday.Intl
5/1/2024
5/13/2024
6/2/2024
8/15/2024
9/7/2024
10/2/2024
10/12/2024
11/2/2024
12/25/2024
Holidays Emp.Name
1/1/2024 Rahul
1/15/2024 Rohit
1/26/2024 Virat
4/9/2024 Pant
5/28/2024 4/11/2024 Karthik
5/1/2024 Hardik
5/13/2024 Dhoni
6/2/2024 Jadeja
8/15/2024 Bhuvi
9/7/2024 Chahal
10/2/2024 Bumrah
10/12/2024
11/2/2024
12/25/2024
EDATE EOMONTH
Date of Joining No. of Months Contract End Date F&F
7/4/2023 34 5/4/2026 1/31/5869
6/23/2026 39 9/23/2029 2/28/5975
10/8/2032 41 3/8/2036 12/31/6177
4/4/2024 23 3/4/2026 9/30/5864
10/3/2031 38 12/3/2034 7/31/6138
5/2/2033 22 3/2/2035 7/31/6147
10/18/2023 50 12/18/2027 9/30/5918
4/6/2032 50 6/6/2036 12/31/6184
2/3/2027 34 12/3/2029 9/30/5981
12/19/2028 45 9/19/2032 8/31/6068
1/19/2027 30 7/19/2029 3/31/5970
UPPER lower Proper
Lokesh Rahul LOKESH RAHUL lokesh rahuLokesh Rah
Rohit SHarma ROHIT SHARMA rohit sharmRohit Shar
Virat Kohli VIRAT KOHLI virat kohli Virat Kohli
Rishabh Pant RISHABH PANT rishabh panRishabh Pan
Dinesh KarthiK DINESH KARTHIK dinesh kartDinesh Kart
Hardik PandYa HARDIK PANDYA hardik pan Hardik Pan
MS Dhoni MS DHONI ms dhoni Ms Dhoni
Ravindra Jadeja RAVINDRA JADEJAravindra ja Ravindra Ja
Bhuvaneshwar KUMarBHUVANESHWAR bhuvaneshw Bhuvaneshw
Yuzvender Chahal YUZVENDER CHAyuzvender Yuzvender
Jasprit Bumrah JASPRIT BUMRAH jasprit bumJasprit Bum
First Name Last Name Concatenate
Lokesh Rahul Lokesh Rahul
Rohit Sharma Rohit Sharma
Virat Kohli Virat Kohli
Rishabh Pant Rishabh Pant
Dinesh Karthik Dinesh Karthik
Hardik Pandya Hardik Pandya
MS Dhoni MS Dhoni
Ravindra Jadeja Ravindra Jadeja
Bhuvaneshwar Kumar Bhuvaneshwar Kumar
Yuzvender Chahal Yuzvender Chahal
Jasprit Bumrah Jasprit Bumrah
Emp1 Emp2 Exact =
Lokesh Rahul Lokesh Rahul 1 1
Rohit SHarma Rohit Sharma FALSE TRUE
Virat Kohli Virat Kohli TRUE TRUE
Rishabh Pant Rishabh Pant TRUE TRUE
Dinesh KarthiK Dinesh Karthik FALSE TRUE
Hardik PandYa Hardik Pandya FALSE TRUE
MS Dhoni Ms Dhenier FALSE FALSE
Ravindra Jadeja Ravindra Jadeja TRUE TRUE
Bhuvaneshwar KUMar Bhuvaneshwar Kuma FALSE TRUE
Yuzvender Chahal Yuzvender Chahal TRUE TRUE
Jasprit Bumrah Jasprit Bumrah TRUE TRUE
Len Left Right Mid
12 L l kesh Lokesh Rahul
12 R a hit Rohit SHarma
11 V i rat Virat Kohli
12 R t shab Rishabh Pant
14 D K nesh Dinesh KarthiK
13 H a rdik Hardik PandYa
8M i Dho MS Dhoni
15 R a vind Ravindra Jadeja
18 B r uvan Bhuvaneshwar KUMar
16 Y l zven Yuzvender Chahal
14 J h spri Jasprit Bumrah
Concat &
Lokesh Rahul Lokesh Rahul Lokesh Rahul
Rohit Sharma Rohit Sharma Rohit SHarma
Virat Kohli Virat Kohli Virat Kohli
Rishabh Pant Rishabh Pant Rishabh Pant
Dinesh Karthik Dinesh Karthik Dinesh KarthiK
Hardik Pandya Hardik Pandya Hardik PandYa
MS Dhoni MS Dhoni MS Dhoni
Ravindra Jadeja Ravindra Jadeja Ravindra Jadeja
Bhuvaneshwar Kumar Bhuvaneshwar Kumar Bhuvaneshwar KUMar
Yuzvender Chahal Yuzvender Chahal Yuzvender Chahal
Jasprit Bumrah Jasprit Bumrah Jasprit Bumrah
Find Search Replace Substitute
8 6 Lokesh DRAVID Lokesh Rahul
8 3 Rohit SHarma 7
9 Virat Kohli
4 Rishabh Pant
6 Dinesh KarthiK
1 Hardik PandYa
5 MS Dhoni
10 Ravindra Jadeja
2 Bhuvaneshwar KUMar
12 Yuzvender Chahal
14 Jasprit Bumrah
Trim
Lokesh Rahul
Rohit SHarma
Virat Kohli
Rishabh Pant
Dinesh KarthiK
Hardik PandYa
MS Dhoni
Ravindra Jadeja
Bhuvaneshwar KUMar
Yuzvender Chahal
Jasprit Bumrah
Clean
Lokesh Rahul
Rohit SHarma
Virat Kohli
Rishabh Pant
Dinesh KarthiK
Hardik PandYa
MS Dhoni
Ravindra Jadeja
Bhuvaneshwar KUMar
Yuzvender Chahal
Jasprit Bumrah
