STATIC DATA DAY MONTH
8/21/2024 Ctrl + ; 8/7/2024
16:57 Ctrl + Shift + ;
DYNAMIC TEXT Functions for Dates
12/5/2024
12/5/2024 12:53 yy
yyyy
mm
mmm
mmmm
dd
ddd
dddd
DATA HOUR MINUTE
04:00:00 PM
hh
mm
ss
YEAR DATE START DATE 8/15/1947
END DATE 8/7/2024
DAY DIFF. Subtract
DAYS
DATEDIF d
DATEDIF m
DATEDIF y
DATEDIF ym
DATEDIF md
DATEDIF yd
8/7/2024 Weekday
Weeknum
YearFrac
SECOND TIME
START DATE 1/1/2024
END DATE 12/31/2024
Net Working Networkdays
Networkdays.Intl
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
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 EMONTH
Date of Joining No. of Months Contract End Date F&F
7/4/2023 34
6/23/2026 39
10/8/2032 41
4/4/2024 23
10/3/2031 38
5/2/2033 22
10/18/2023 50
4/6/2032 50
2/3/2027 34
12/19/2028 45
1/19/2027 30
UPPER lower Proper
Lokesh Rahul
Rohit SHarma
Virat Kohli
Rishabh Pant
Dinesh KarthiK
Hardik PandYa
MS Dhoni
Ravindra Jadeja
Bhuvaneshwar KUMar
Yuzvender Chahal
Jasprit Bumrah
First Name Last Name Concatenate
Lokesh Rahul
Rohit Sharma
Virat Kohli
Rishabh Pant
Dinesh Karthik
Hardik Pandya
MS Dhoni
Ravindra Jadeja
Bhuvaneshwar Kumar
Yuzvender Chahal
Jasprit Bumrah
Emp1 Emp2 Exact =
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 Dhenier
Ravindra Jadeja Ravindra Jadeja
Bhuvaneshwar KUMar Bhuvaneshwar Kumar
Yuzvender Chahal Yuzvender Chahal
Jasprit Bumrah Jasprit Bumrah
Len Left Right Mid
Lokesh Rahul
Rohit SHarma
Virat Kohli
Rishabh Pant
Dinesh KarthiK
Hardik PandYa
MS Dhoni
Ravindra Jadeja
Bhuvaneshwar KUMar
Yuzvender Chahal
Jasprit Bumrah
Concat &
Lokesh Rahul
Rohit SHarma
Virat Kohli
Rishabh Pant
Dinesh KarthiK
Hardik PandYa
MS Dhoni
Ravindra Jadeja
Bhuvaneshwar KUMar
Yuzvender Chahal
Jasprit Bumrah
Find Search Replace Substitute
Trim
Clean
ar KUMar
