100 Nos Of Formula and Functions
In MSExcel
Part 4
61-80: Date and Time Functions
61. NOW - Returns the current date
and time.
o Example: =NOW()
62.TODAY - Returns the current date.
o Example: =TODAY()
63.YEAR - Extracts the year from a
date.
o Example: =YEAR(A1)
64.MONTH - Extracts the month from a
date.
o Example: =MONTH(A1)
65.DAY - Extracts the day from a date.
o Example: =DAY(A1)
66.HOUR - Extracts the hour from a
time.
o Example: =HOUR(A1)
67.MINUTE - Extracts the minute from a
time.
o Example: =MINUTE(A1)
68.SECOND - Extracts the second from a
time.
o Example: =SECOND(A1)
69.WEEKDAY - Returns the day of the
week as a number.
o Example: =WEEKDAY(A1)
70.WEEKNUM - Returns the week number of
the year.
o Example: =WEEKNUM(A1)
71. DATEDIF - Calculates the
difference between two dates.
o Example: =DATEDIF(A1, B1,
"d")
72.EDATE - Adds or subtracts months
to/from a date.
o Example: =EDATE(A1, 3)
73.EOMONTH - Returns the last day of
the month after a certain number of months.
o Example: =EOMONTH(A1, 1)
74.DATE - Creates a date from year,
month, and day.
o Example: =DATE(2024, 10,
25)
75.TIME - Creates a time from hour,
minute, and second.
o Example: =TIME(14, 30, 0)
76.YEARFRAC - Calculates the fraction
of the year between two dates.
o Example: =YEARFRAC(A1, B1)
77.NETWORKDAYS - Counts the workdays
between two dates.
o Example: =NETWORKDAYS(A1,
B1)
78.WORKDAY - Calculates the workday
after a specified number of days.
o Example: =WORKDAY(A1, 5)
79.ISOWEEKNUM - Returns the ISO week
number of the year.
o Example: =ISOWEEKNUM(A1)
80.DATEDIF (alternative use) - With
different units, like "y" for years, "m" for months, or
"d" for days.
o Example: =DATEDIF(A1, B1,
"m")
