Python Refresher - Numbers (1 minute)

Python Refresher

Python Refresher - Numbers - 1 minute read.     

Know the Differences Between Co-op and Internship

Know the Differences Between Co-op and Internship

A co-op or internship can be useful because many businesses want students to have relevant work experience when they graduate from college. When comparing co-op and internship possibilities, students ...

You can learn about management consulting without attending a prestigious university. For their well-liked online strategy courses, several prestigious universities charge extremely hefty tuition. The...

How to fake yourself to success?

How to fake yourself to success?

It is pretty rare that we all like every minute of our daily work. Sometimes (or most of the time!), whether we like it or not, we have to be part of a meeting or a celebration that we hate very much....

Social Media – Should you POST it?!

This is the era of social media. Whether we like it or not, social media is everywhere. We tend to take snaps of our everyday life and post it in our social media accounts.    Sometimes, knowingly, ...

Question # 02: How do I set realistic sales goals?

HTML - How can I add a caption under an image?

HTML - How can I add a caption under an image? HTML5 offers a great tag to make life easy for web developers.   Say you have a couple of images and would like to add a caption under each image, ...

CSS - How to apply style changes only to specific text inside a tag? When you want to apply specific CSS inline style to some text inside a HTML tag, you can use tag.   The above code will...

We are in a difficult period. ‘N’ number of jobs are cut and hence competition to get a job has increased multi-fold. It is important to set yourself apart from your contemporaries to secure and / or...

Quality - CMMI Processes for Software Testing

CMMI models are collections of best practices that you can compare to an organization's best practices and guide improvement to the processes. In this article, let us talk about the key checklists to...

Quality - Advanced Product Quality Planning (APQP)

APQP or Advanced Product Quality Planning is a quality framework developed by a commission of experts gathered from Ford, General Motors and Chrysler. This framework is used by Organizations for devel...

Quality - Just In Time (JIT)

The purpose of any Business is Profit and a commensurate Return on Investment (ROI). An industry thrives in a market by offering goods or services and while doing so sees to it that its turnover and p...

More Articles

More From: Python Scoop Entrepreneurship Emotional Intelligence Nirva – Problems and Solutions HTML IT Certifications Quality Unix & Linux

(Reading time: 1 minute)

Excel

In Excel, the DateDiff function returns the difference between two date values, based on the interval specified.

The syntax for the DateDiff function is:

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

interval is the interval of time to use to calculate the difference between date1 and date2. Below is a list of valid interval values.

  • yyyy - Year
  • q - Quarter
  • m - Month
  • y - Day of year
  • d - Day
  • w - Weekday
  • ww - Week
  • h - Hour
  • n - Minute
  • s - Second

date1 and date2 are the two dates to calculate the difference between.

firstdayofweek is optional. It is a constant that specifies the first day of the week. If this parameter is omitted, Excel assumes that Sunday is the first day of the week.

firstweekofyear is optional. It is a constant that specifies the first week of the year. If this parameter is omitted, Excel assumes that the week containing Jan 1st is the first week of the year.


Example

 
 
 
Sub TestDates 
 
 
     mydiff = DateDiff("d", "8/14/09", "8/14/10")
 
 
End Function
 
 
 

Oxygen
Author: Oxygen
Other articles by this author

Chillzee Tag Cloud

Let's Socialize

About Chillzee

Chillzee.com is an entrepreneurship portal.

The site provides informative topics on Organizational and Strategic needs.