Date 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.

How to use Date and Time Formulas in Excel

The article in this webpage describes how to use the Date and Time functions in Excel with the syntax, arguments, detailed explanation, and examples step by step.

Click on any of the below Date and Time formulas in Excel to get the detailed information about it.

Function
Description
DATE Function
Serial number of a date based on year, month and day.
DATEDIF Function
Number of days, months or years between two dates.
DATEVALUE Function
Convert a date in the text format to a serial number.
DAY Function
Calculate the day value from a date.
DAYS Function
Number of days between two dates.
DAYS360 Function
Number of days between two dates based on 360 days in a year.
EDATE Function
Past or future month(s) from a start date.
EMONTH Function
Last day of the month before or after a given number of months.
HOUR Function
Hour (0 to 23) from a time value.
ISOWEEKNUM Function
Week number from a date based on ISO (International Organization for Standardization).
MINUTE Function
Minute (0 to 59) from a time value.
MONTH Function
Month (1 to 12) from a time value.
NETWORKDAYS Function
Number of working days between two dates using holidays.
NETWORKDAYS.INTL Function
Number of working days between two dates using weekend days.
NOW Function
Current date and time.
SECOND Function
Second (0 to 59) from a time value.
TIME Function
Decimal number for a secific time.
TIMEVALUE Function
Decimal number for a secific time in the form of text.
TODAY Function
Current date.
WEEDAY Function
Day of the week (1 to 7) from a date.
WEEKNUM Function
Week number (1 to 54) from a date.
WORKDAY Function
Date before or after a specified number of working days.
WORKDAY.INTL Function
Date before or after a specified number of working days using weekend days.
YEAR Function
Year (1900 to 9999) from a date.
YEARFRAC Function
Year or fraction of the year between two dates.

Learn More

Function
Description
XLOOKUP Function
Search for a specified value from a table or range of cells.
DATEDIF Function
Number of days, months or years between two dates.

0 Comments

Date and Time Formulas in Excel

Excel Formulas (Category)

» Financial Formulas in Excel

» Logical Formulas in Excel

» Text Formulas in Excel

» Date and Time Formulas in Excel

» Lookup and Reference Formulas in Excel

» Math and Trig Formulas in Excel

» Statistical Formulas in Excel

» Engineering Formulas in Excel

» Cube Formulas in Excel

» Information Formulas in Excel

» Compatibility Formulas in Excel

» Web Formulas in Excel

Excel Tutorial Part 1 (Basic)

» Excel Basics

» Excel Home

» Excel Workbook

» Excel Template

» Excel Cell

» Excel Password

Excel Tutorial Part 2 (Format)

» Excel Clipboard

» Excel Format Font

» Excel Format Alignment

» Excel Format Number

» Excel Border

» Excel Conditional Formatting

Excel Tutorial Part 3 (Data)

» Excel Sort Data

» Excel Filter Data

» Excel Text to Columns

» Excel Data Validation

» Excel Flash Fill

» Excel Remove Duplicates

» Excel Relationships

» Excel Consolidate

» Excel What-If Analysis

» Excel Group

» Excel Charts

» Excel Table

» Excel PivotTable

Excel Tutorial Part 4 (Find)

» Excel Find and Replace

» Excel Go To

» Excel Select Objects

» Excel Selection Pane

Excel Tutorial Part 5 (Review)

» Excel Spell Check

» Excel Smart Lookup

» Excel Translate

» Excel Comments & Notes

» Excel Protect

» Excel Hide Ink

Excel Tutorial Part 6 (View)

» Excel Workbook Views

» Excel Formula Bar

» Excel Zoom

» Excel Window

» Excel Macros

Excel Tutorial Part 7 (Fx)

» Excel Formulas (Category)

» Excel Formulas (Alphabetical Order)

» Excel Errors

» Excel Name Manager

» Excel Formula Auditing

» Excel Watch Window

» Excel Calculation Options

Excel Tutorial Part 8 (Other)

» Excel Add-ins

» Excel Shortcuts