Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to calculate two-way lookup VLOOKUP in Excel Table
  • How to get address of first cell in range in Excel
  • Basic INDEX MATCH approximate in Excel
  • How to use Excel MMULT Function
  • How to use Excel MATCH Function

Data Analysis Examples

  • Conditional Formatting Data bars Examples in Excel
  • How To Compare Two Lists in Excel
  • Calculate Conditional Percentile ‘IF’ in table in Excel
  • How To Create Pareto Chart in Excel
  • How to count table rows in Excel

Data Validation Examples

  • Excel Data validation require unique number
  • Excel Data validation date in specific year
  • Excel Data validation unique values only
  • Excel Data validation with conditional list
  • Excel Data validation must not contain

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.

Worked Example:   Convert text date dd/mm/yy to mm/dd/yy in Excel

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.

Worked Example:   Get date from day number in Excel

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.

Worked Example:   Highlight dates between 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:

Count and Sum Functions in Excel

Next Post:

Cell References: Relative, Absolute and Mixed Referencing Examples

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
  • How to check if cell contains some words but not others in Excel
  • Remove text by variable position in a cell in Excel
  • How to convert text string to array in Excel
  • REPT function: Description, Usage, Syntax, Examples and Explanation
  • How to count total words in a cell in Excel
  • Calculate time difference in hours as decimal value in Excel
  • Convert date to Julian format in Excel
  • Get days between dates ignoring years in Excel
  • Get age from birthday in Excel
  • Sum race time splits in Excel
  • PMT function: Description, Usage, Syntax, Examples and Explanation
  • MIRR function: Description, Usage, Syntax, Examples and Explanation
  • CUMPRINC function: Description, Usage, Syntax, Examples and Explanation
  • XNPV function: Description, Usage, Syntax, Examples and Explanation
  • Future value vs. Present value examples in Excel
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles