YEAR Date of
First Name Last Name DEPARTMENT RANK HIRED Hiring Gender SALARY
John Smith Accounting Assistant 1989 12/12/1989 F 49,955.00
Roger Greenwood Sales Executive 1971 4/3/1971 M 56,281.00
Anna Cyrus Finance Associate 1978 8/25/1978 M 44,212.00
Jack Wobler Finance Manager 1977 6/15/1977 F 52,339.00
Micheal Hudson Accounting Assistant 1990 7/18/1990 F 45,371.00
Ronny Blacksmith Accounting Instructor 1992 8/9/1992 F 33,781.00
Amy Brooks Accounting Instructor 1987 1/28/1987 M 36,582.00
Walton Miller Accounting Manager 1978 2/12/1978 M 52,105.00
Nancy Paul Sales Associate 1983 9/10/1983 F 44,918.00
Roberto Rodriguez Finance Associate 1976 11/3/1976 M 46,281.00
Jasmine White Sales Associate 1982 10/28/1982 F 46,887.56
Concatenate/Concat Left Right Find Search Len
Mid Replace Substitute
Trim Upper Lower Proper
₹ 8,159.00
₹ 8,962.00
₹ 7,409.00
###
00001254
###
###
###
###
###
###
600000
700000
900000
Year Month
4/1/2020 2020 4
4/10/2021 2021 4
4/20/2022 2022 4
3/26/2009 2009 3
8/15/2011 2011 8
1/26/2012 2012 1
50workdays
from start Consider
Today's date date holidays
Start date 4/1/2020 6/10/2020 6/12/2020
End date 4/30/2020
NetWorkdays between (excluding
holidays) 20
NetWorkdays between (no
holidays) 22
=NETWORKDAYS(B14,B15,E17:E18)
=B5 =TEXT(G5,"YYYY,MMMM D,DDDD")
Day Day of Week Putting date together Text
1 Wednesday 4/1/2020 2020,April 1,Wednesday
10 Saturday 4/10/2021 2021,April 10,Saturday
20 Wednesday 4/20/2022 2022,April 20,Wednesday
26 Thursday 3/26/2009 2009,March 26,Thursday
15 Monday 8/15/2011 2011,August 15,Monday
26 Thursday 1/26/2012 2012,January 26,Thursday
=WORKDAY(B14,50)
Holidays
4/10/2020
4/20/2020
MM D,DDDD")
Calculate the Age using Datedif function
Date of Birth Age Date of Birth Age
12/31/1978 46 12/12/1970 54
5/24/1982 42 12/26/2000 24
7/14/1952 72 8/15/1947 77
Calculate the Age using yearfrac function and Round of the decimal by using rounddown fun
Birth Date Today Age
5/12/1982 4/30/2025 42 =ROUNDDOWN(YEARFRAC(D9,E9),0)
12/31/1978 4/30/2025 46
5/24/1982 4/30/2025 42
7/14/1952 4/30/2025 72
Calculate the no. of years, months and days till today using datedif function
Date of Joining Today's Date No. of years No. of Months No. of Days
1/1/1990 4/30/2025
6/3/1998 4/30/2025
12/31/1978 4/30/2025
5/24/1982 4/30/2025
7/14/1952 4/30/2025
Age as on today (roundup)
Different in two dates (date of joining, total years completed, 6 months and above full year
total days worked-year, months, and days
al by using rounddown function
ARFRAC(D9,E9),0)
Date of Joining Today's Date No. of years
1/1/1990
6/3/1998
12/31/1978
5/24/1982
7/14/1952
s and above full year
No. of Months No. of Days
Date Previous month's 1st Day
5/1/2021 4/1/2021 =DATE(YEAR(C3),MONTH(C3)-1,1)
7/10/2021 6/1/2021
8/22/2021 7/1/2021
Date Next Month's First Day
4/1/2021 5/1/2021 =DATE(YEAR(C9),MONTH(C9)+1,1)
6/1/2021 7/1/2021
7/1/2021 8/1/2021
Date Same Day After 2 Months
6/1/2021 8/1/2021 =EDATE(C15,2)
8/1/2021 10/1/2021
9/1/2021 11/1/2021
3),MONTH(C3)-1,1)
9),MONTH(C9)+1,1)
