Date and Time Formulas in Excel
Date and time formulas in Excel are used to return the desired output from the date and time in Excel, such as year, month, day, hour, minute, second etc. Some of the date and time formulas are new and may not be available in old Excel versions.
In this tutorial page, you will learn how to use all the date and time formulas in Excel with detailed explanations, examples and videos.
Date and Time Formulas in Excel | Rath Point
All Date and Time Formulas in Excel
Click on any of the below date and time formulas in Excel to get the detailed information about it.
DATE Formula in Excel
DATEDIF Formula in Excel
DATEVALUE Formula in Excel
DAY Formula in Excel
DAYS Formula in Excel
DAYS360 Formula in Excel
EDATE Formula in Excel
EMONTH Formula in Excel
HOUR Formula in Excel
ISOWEEKNUM Formula in Excel
MINUTE Formula in Excel
MONTH Formula in Excel
NETWORKDAYS Formula in Excel
NETWORKDAYS.INTL Formula in Excel
NOW Formula in Excel
SECOND Formula in Excel
TIME Formula in Excel
TIMEVALUE Formula in Excel
TODAY Formula in Excel
WEEKDAY Formula in Excel
WEEKNUM Formula in Excel
WORKDAY Formula in Excel
WORKDAY.INTL Formula in Excel
YEAR Formula in Excel
YEARFRAC Formula in Excel
Summary of all Date and Time Formulas in Excel
DATE
Serial number of a date based on year, month and day.
DATEDIF
Number of days, months or years between two dates.
DATEVALUE
Convert a date in the text format to a serial number.
DAY
Calculate the day value from a date.
DAYS
Number of days between two dates.
DAYS360
Number of days between two dates based on 360 days in a year.
EDATE
Past or future month(s) from a start date.
EMONTH
Last day of the month before or after a given number of months.
HOUR
Hour (0 to 23) from a time value.
ISOWEEKNUM
Week number from a date based on ISO (International Organization for Standardization).
MINUTE
Minute (0 to 59) from a time value.
MONTH
Month (1 to 12) from a time value.
NETWORKDAYS
Number of working days between two dates using holidays.
NETWORKDAYS.INTL
Number of working days between two dates using weekend days.
NOW
Current date and time.
SECOND
Second (0 to 59) from a time value.
TIME
Decimal number for a secific time.
TIMEVALUE
Decimal number for a secific time in the form of text.
TODAY
Current date.
WEEDAY
Day of the week (1 to 7) from a date.
WEEKNUM
Week number (1 to 54) from a date.
WORKDAY
Date before or after a specified number of working days.
WORKDAY.INTL
Date before or after a specified number of working days using weekend days.
YEAR
Year (1900 to 9999) from a date.
YEARFRAC
Year or fraction of the year between two dates.
» Financial Formulas
» Logical Formulas
» Text Formulas
» Date & Time Formulas
» Lookup & Ref Formulas
» Math & Trig Formulas
» Statistical Formulas
» Engineering Formulas
» Cube Formulas
» Information Formulas
» Compatibility Formulas
» Web Formulas