Learn about everything generating date and time in excel using functions

NOW() function

NOW() function gives your system current date and time. The result or the format of the date and time depends on your system.

Formula:=NOW()

	A	B	C
1	Now function	=NOW()	10/2/2022 20:30

TODAY() function

TODAY() function only gives your system current date . The result or the format of the date depends on your system.

Formula:=TODAY()

	A	B	C
1	Now function	=TODAY()()	10/2/2022

DAY() function

DAY() function only gives the day of the month according to your system current date. This is will numbered the day between 1 to 31. 1 is the first day and 31 is the last day of the month

Formula:=DAY(TODAY())

	A	B	C
1	Now function	=DAY(TODAY())	2

MONTH() function

MONTH() function only gives the number of month according to your system current date. This is will numbered the day between 1 to 12. 1 is the first month and 12 is the last month of the year

Formula:=MONTH(TODAY())

	A	B	C
1	Now function	=MONTH(TODAY())	10

YEAR() function

YEAR() function only gives the year according to your system current date. This is will

Formula:=YEAR(TODAY())

	A	B	C
1	Now function	=YEAR(TODAY())	2022

HOUR() function

HOUR() function only gives hour according to your system current time. This is will number the hour 0 to 23. Here 0 means 12 AM and 23 means 11 PM.

Formula:=HOUR(NOW())

	A	B	C
1	Now function	=HOUR(NOW())	20

MINUTE() function

MINUTE() function only gives minute according to your system current time. This is will number the hour 0 to 59.

Formula:=MINUTE(NOW())

	A	B	C
1	Now function	=MINUTE(NOW())	35

SECOND() function

SECOND() function only gives second according to your system current time. This is will number the second 0 to 59.

Formula:=SECOND(NOW())

	A	B	C
1	Now function	=SECOND(NOW())	35