Excel DateDiff function

Date & Time Functions

Excel Functions

File System Functions

Vector and Matrix Functions

All Functions Index

ExcelLock: Lock and secure your valuable Excel spreadsheets

encOffice: Protect your Excel file easy and safe

Date & Time functions

		LITlib - Excel Power Functions Pack

		Add-in for Excel that adds additional cell functions to Excel.

litLIB Help - DateDiff function

litLIB Help

Product pages :
litLIB

Quick links:
help index
forums

Date and Time - DateDiff

Syntax:
=DateDiff(Interval, Date1, Date2, Optional FirstDayOfWeek, Optional FirstWeekOfYear)

Description:
Returns the number of intervals between two dates/times.

Interval :

yyyy	year	q	quarter
m	month	d	day
ww	week	w	weekday
y	day of year	h	hour
n	minute	s	second

Date1 :

First date and time to consider

Date2 :

Second date and time to compare with.

FirstDayofWeek :

Optional. This constant specifies which day is considered to be the start of the week. 0 is the system default, 1 is Sunday, 2 is Monday, 3 is Tuesday, and so on.

FirstWeekOfYear :

Optional. This constant specifies the first week of the year. If not specified the first week of the year is considered the week of January the 1st. 0 is the system default, 1 is week of January the 1st, 2 starts with the week that has at least 4 days, 3 starts the year with the first full week.

Example:

Compute the number of years between the two dates given.
=DateDiff("yyyy","01/01/2000","01/01/2003")

Compute the number of quarters between the two dates given.
=DateDiff("q","01/01/2000","01/07/2000")

Compute the number of months between the two dates given.
=DateDiff("m","01/01/2000","01/07/2000")

Compute the number of days between the two dates given.
=DateDiff("d","01/01/2000","10/01/2000")

Compute the number of weeks between the two dates given.
=DateDiff("ww","01/01/2000","01/02/2000")

Compute the number of hours between the two times given.
=DateDiff("h","12:05:30","15:30:10")

Compute the number of minutes between the two times given.
=DateDiff("n","12:05:30","12:09:35")

Compute the number of seconds between the two times given.
=DateDiff("s","12:05:30","12:05:35")

Similar functions:
WeekDays, WeekendDays

These functions are available in the litLIB power functions library for Excel:

litLIB

Copyright (C) 1995-2010 Linker IT Software BV. All Rights Reserved. Oracle is a registered trademark of Oracle corporation. Excel and Office are registered trademarks of Microsoft corporation. Other names appearing on the site may be trademarks of their respective owners. Software, files, documents, articles and other material are provided "as is" and without warranties as to performance or mechantability or any other warranties whether expressed or implied. No warranty of fitness for a particular purpose is offered.
sitemap