Day,Days,Date,Month,Year Function in Excel

 

 Day Function

 

=DAY(A2)

	A	B
1	Date	Day
2	8/12/2023	12
3	8/25/2023	25
4	4/14/2023	14
5	4/26/2023	26

 

Days Function

 

=DAYS(B2,A2)

 

	A	B	C
1	Start Date	End date	Days
2	11/15/1989	10/25/1992	1075
3	5/23/2022	8/23/2023	457
4	6/5/2000	3/6/2021	7579
5	6/21/2021	6/22/2022	366

 

Date Function

 

=DATE(A2,B2,C2)

 

	A	B	C	D
1	Day	Month	Year	Date
2	15	12	2003	12/15/2003
3	26	10	2004	10/26/2004
4	5	9	1999	9/5/1999
5	28	4	1998	4/28/1998

 

Month Function

 

=MONTH(A2)

 

	A	B
1	Date	Month
2	8/12/2023	8
3	8/25/2023	8
4	4/14/2023	4
5	4/26/2023	4

 

Year Function

 

=YEAR(A2)

 

	A	B
1	Date	Year
2	8/12/2024	2024
3	8/25/2023	2023
4	4/14/2027	2027
5	4/26/2023	2023