Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How to calculate average last N values in a table in Excel
  • Understanding Anova in Excel
  • Conditional Formatting Color Scales Examples in Excel
  • How to create Checklist in Excel
  • Working With Tables in Excel

References

  • Lookup entire row in Excel
  • Multi-criteria lookup and transpose in Excel
  • How to get last column number in range in Excel
  • How to get last row in numeric data in Excel
  • Count rows that contain specific values in Excel

Data Validations

  • Excel Data validation unique values only
  • Excel Data validation must contain specific text
  • Excel Data validation exists in list
  • How To Create Drop-down List in Excel
  • Excel Data validation must begin with

Excel Date & Time Functions Example

by

To enter a date in Excel, use the “/” or “-” characters. To enter a time, use the “:” (colon). You can also enter a date and a time in one cell.

Note: Dates are in US Format. Months first, Days second. This type of format depends on your windows regional settings. Learn more about Date and Time formats.

Year, Month, Day

To get the year of a date, use the YEAR function.

Note: use the MONTH and DAY function to get the month and day of a date.

Date Function

1. To add a number of days to a date, use the following simple formula.

2. To add a number of years, months and/or days, use the DATE function.

Note: the DATE function accepts three arguments: year, month and day. Excel knows that 6 + 2 = 8 = August has 31 days and rolls over to the next month (23 August + 9 days = 1 September).

Current Date & Time

To get the current date and time, use the NOW function.

Note: use the TODAY function to enter today’s date in Excel.

Hour, Minute, Second

To return the hour, use the HOUR function.

Note: use the MINUTE and SECOND function to return the minute and second.

Time Function

To add a number of hours, minutes and/or seconds, use the TIME function.

Note: Excel adds 2 hours, 10 + 1 = 11 minutes and 70 – 60 = 10 seconds.

Post navigation

Previous Post:

TRUE function: Description, Usage, Syntax, Examples and Explanation

Next Post:

Excel Pie Chart

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • IF with boolean logic in Excel
  • Return blank if in Excel
  • Invoice status with nested if in Excel
  • IF function: Description, Usage, Syntax, Examples and Explanation
  • SWITCH function example in Excel

Date Time

  • Convert text timestamp into time in Excel
  • Get month from date in Excel
  • Convert text date dd/mm/yy to mm/dd/yy in Excel
  • Display Date is same month in Excel
  • How to join date and text together in Excel

Grouping

  • How to randomly assign data to groups in Excel
  • Calculate conditional mode with criteria in Excel
  • Group times into 3 hour buckets in Excel
  • If cell contains one of many things in Excel
  • Group numbers with VLOOKUP in Excel

General

  • Sum by group in Excel
  • Subtotal by invoice number in Excel
  • Using Existing Templates in Excel
  • How to generate random number weighted probability in Excel
  • With vs Without Array Formula in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning