Advanced Excel
  • Introduction to Excel
  • Security
  • Short Keys
  • Practice Data Sheets
  • Data Formats
  • Conditional Formatting
  • Format as Table
  • Data Sorting
  • Data Filtering
  • Remove Duplicates
  • Data Validation
  • Text-To-Columns
  • Data Consolidation
  • What-if-Analysis
  • Grouping
  • Absolute & Relative Referencing
  • Mathematical Functions - Sum, Sumif, Sumifs, Count, Counta, Countif, Max, Min, Average
  • Task1 - Mathematical Formulas
  • Logical Functions - IF, IFERROR, AND, OR
  • Date Time Functions - Date, Year, Month, Day, Time, Hour, Minute, Second, Today, Now, Datedif
  • Text Functions - Proper, Left, Right, Concatenate, Exact, Find, Search, Mid, Replace, Text, Replace
  • Vlookup Formula
  • Task2 - Vlookup Problems
  • Vlookup with Match Formula - Dynamic Duo
  • Vlookup using (*) example
  • Vlookup with Running Countif
  • Task3 - Vlookup, Running Countif Problem
  • Lookup Functions - Hlookup, Index Match
  • Lookup Functions - Indirect, Offset
  • Vlookup-Indirect Example
  • Sumif, Indirect, Offset, Match Example
  • Array Functions
  • Task4 - Array Problem
  • Advanced Conditional Formatting using Formula
  • Data Validation using Indirect Function
  • Charts, Waterfall Graph
  • Pivot Table, Dashboards
Powered by GitBook
On this page

Was this helpful?

Date Time Functions - Date, Year, Month, Day, Time, Hour, Minute, Second, Today, Now, Datedif

Date

Returns a date, from a user-supplied year, month and day

=DATE(year, month, day)

Year

Returns the year from a user-supplied date

=YEAR(serial_number)

Month

Returns the month from a user-supplied date

=MONTH(serial_number)

Day

Returns the day (of the month) from a user-supplied date

=DAY(serial_number)

Time

Returns a time, from a user-supplied hour, minute and second

=TIME(hour, minute, second)

Hour

Returns the hour part of a user-supplied time

=HOUR(serial_number)

Minute

Returns the minute part of a user-supplied time

=MINUTE(serial_number)

Second

Returns the seconds part of a user-supplied time

=SECOND(serial_number)

Today

Returns today's date

=TODAY()

Now

Returns the current date & time

=NOW()

DatedIf

The Microsoft Excel DATEDIF function returns the difference between two date values, based on the interval specified.

The DATEDIF function is a built-in function in Excel that is categorized as a Date/Time Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the DATEDIF function can be entered as part of a formula in a cell of a worksheet.

=DATEDIF(start_date, end_date, return_unit)

PreviousLogical Functions - IF, IFERROR, AND, ORNextText Functions - Proper, Left, Right, Concatenate, Exact, Find, Search, Mid, Replace, Text, Replace

Last updated 6 years ago

Was this helpful?

47KB
Date-Time Function.xlsx
Date-Time Formulas Examples