Excel Formulas

Date Time Excel Formula Examples

Copy-paste examples for date time formulas in Excel.

💡 Ideas for You

Helpful resources matched to this page.

4 focused options
📚 Step-by-step booksIndependent learning resources and step-by-step books from Create & Learn.📘 Topic guideAmazon ideas related to Date Time.🧮 Formula booksBooks and references for spreadsheet formulas and examples.⌨️ Productivity setupHelpful books, office tools, and productivity resources.

Browse formulas

Choose a formula page for copy-paste examples, step-by-step notes, and common mistakes.

fx

TODAY Formula

Return the current date.

fx

NOW Formula

Return the current date and time.

fx

DATE Formula

Create a date from year, month, and day numbers.

fx

DATEDIF Formula

Calculate the difference between two dates.

fx

YEARFRAC Formula

Calculate fractional years between dates.

fx

EDATE Formula

Add or subtract months from a date.

fx

EOMONTH Formula

Return the last day of a month.

fx

WORKDAY Formula

Add working days to a date.

fx

NETWORKDAYS Formula

Count working days between dates.

fx

WEEKDAY Formula

Return the day of week number for a date.

fx

WEEKNUM Formula

Return the week number for a date.

fx

MONTH Formula

Return the month number from a date.

fx

YEAR Formula

Return the year from a date.

fx

DAY Formula

Return the day number from a date.

fx

TIME Formula

Create a time value from hour, minute, and second.

fx

HOUR Formula

Return the hour from a time.

fx

MINUTE Formula

Return the minute from a time.

fx

SECOND Formula

Return the second from a time.