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

Lookup and Reference Examples

  • How to get relative row numbers in a range in Excel
  • Count rows that contain specific values in Excel
  • How to use Excel TRANSPOSE Function
  • Last row number in range
  • Two-way lookup with VLOOKUP in Excel

Data Analysis Examples

  • How To Create Pareto Chart in Excel
  • How to Create Gantt Chart in Excel
  • Use Data Form to input, edit and delete records in Excel
  • Conditional Formatting Data bars Examples in Excel
  • How to perform a t-Test in Excel

Data Validation Examples

  • Excel Data validation unique values only
  • Excel Data validation must contain specific text
  • Excel Data validation require unique number
  • Excel Data validation date in next 30 days
  • Excel Data validation with conditional list

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:   Highlight dates between 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:   DATE function: Description, Usage, Syntax, Examples and Explanation

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:   YEAR function: Description, Usage, Syntax, Examples and Explanation

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
  • MID, MIDB functions: Description, Usage, Syntax, Examples and Explanation
  • How to remove trailing slash from url in Excel
  • How to display conditional message with REPT function in Excel
  • How to extract word containing specific text in Excel
  • How to extract domain from email address in Excel
  • Custom weekday abbreviation in Excel
  • List holidays between two dates in Excel
  • Calculate time difference in hours as decimal value in Excel
  • WORKDAY function: Description, Usage, Syntax, Examples and Explanation
  • Assign points based on late time in Excel
  • PRICEDISC function: Description, Usage, Syntax, Examples and Explanation
  • PPMT function: Description, Usage, Syntax, Examples and Explanation
  • DDB function: Description, Usage, Syntax, Examples and Explanation
  • ODDLPRICE function: Description, Usage, Syntax, Examples and Explanation
  • RATE function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles