Excel DateDiff Function: Calculate Frequencies Between Dates

The DateDiff Excel function is used to calculate the number of frequencies between two dates such as weeks, quarters, years, days etc.

The Basics:

DateDiff( interval, date1, date2, firstdayofweek, firstweekofyear )

Interval = What interval you want to use such as ‘yyyy’ for year, ‘ww’ for weeks etc.

Date1 = The first date

Date2 = The second date

Firstdayofweek = What day is considered the first day of the week. The value is optional and the default value is set at Sunday

Firstweekofyear = You can define the first week based on what you require. For example the default value for the first week is the week in which Jan 1 appears.

Now let’s look at an example. Let’s assume we want to calculate the frequency intervals between two dates based on weeks, days and quarters.