FAQ Officetipps.net - Differenz zwischen zwei Daten (Plural von Datum)

Excel

ID #1002

Differenz zwischen zwei Daten (Plural von Datum)

Bei diesen Formeln wird unterstellt, dass in den Zellen A1 bzw. B1 jeweils ein Datum steht. Also das Ausgangs- bzw. das Enddatum.



=DATEDIF(A1;B1;"d") in Tagen



=DATEDIF(A1;B1;"m") in Monaten



=DATEDIF(A1;B1;"y") in Jahren

Syntax:
=DATEDIF(Start;Ende;"d")

Tags: -

Verwandte Artikel:

78837/59%Letzte Änderung des Artikels: 2005-10-16 11:39
Verfasser des Artikels: Horst Schulte
Revision: 1.0

Es ist möglich, diesen Artikel kommentieren

Kommentar von wow power leveling:
wow power leveling cheap wow gold count under their own diminishing returns aion gold buy wow gold but I think such a lazy person will never be wow power leveling cheap wow power leveling the first to calculate what tankspot wedding dresses buy wow power leveling of diminishing returns has long rolex cheap wow gold been compared to the detailed calculation argument louis vuitton handbags for the relevant translation xyj xyjjgijgsjl
Added at: 2010-06-03 07:09

Kommentar von cheap coach bags:
A famous item that every woman wants is cheap Coach handbags. There are so many brands of Coach handbags that will suit your lifestyle and personality. You can find all styles affordable loves you more online or in Coach outlet store. Now the coach outlet store has become more and more popular, cause there are so many authentic cheap coach bags on sale this season.
Added at: 2010-06-30 04:51

Kommentar von nike shoes:
The nike dunk shoes is a timeless piece which has seen a plethora of colorways this year alone, and nike dunks continues to produce new versions. Jordan has been used every year to replace his boots, and a growing number of admirers have begun to follow this custom, which makes high top nike dunks become special significance.
Added at: 2010-06-30 04:55

Kommentar von wow:
Wir bieten alle gold wow Dienstleistungen.
Added at: 2010-07-07 03:45

Kommentar von lida daidiahua:
Since 2003, the different hermes bags collections are even more popular and well-known in the world. At that time, the famous designer Jean-Paul Gaultier joined birkin group. In the group he took a position of "ready to wear" collections for women berkin bag designer. Herbal diet supplements and lida and prescribed or doctor recommended weight loss product. If you expect to lose lots of pounds with this kind of lida daidaihua then you should think again. What these daidaihua can help you with however, lida slimming is giving you some extra psychological motivation as well as slimming capsule curbing the edge off your food cravings and your appetite. Don’t expect miracles – stay realistic. The first thing you should do if you consider to buy these kinds of slimming capsules is to read the label very carefully. However Chanel bag come with high price tags and we can not afford Chanel Wallet , there are still some people are willing to append their several month's salary to buy Chanel handbags , but they get into debt. It is not available. One more thing that Tiffany is known for is the expensive price tags attached to their products. Hence, many people are always on the lookout for discount silver earrings . But the question is: is there such a thing as discount Tiffany necklaces ? Given the pedigree of the brand, wouldn’t silver necklaces line of products remain expensive?
Added at: 2010-07-22 04:42

Kommentar von chanel:
A hermes obsession takes a lot of work. The prestige and appeal that comes with owning one of handbag hermes timeless bags is not easily acquired. The most famous handbags hermes , the Kelly Bag, is among those most coveted by “bag snobs”. Herbal lida daidaihua has side effects too and if daidaihua contains ingredients that you know you can’t tolerate or interact with other medication you are on, simply don’t use lida slimming . Also keep to the recommended slimming capsule dose. The herbal slimming capsules market place is not regulated, which means there are many actors on the stage whose lida sole purpose is to make short term money and nothing else. Appearance of Chanel Wallet solved most people's financial problem. Chanel handbags are much cheaper and more affordable for most people. How about the replica Chanel handbags ? This is especially true on the internet, where many discount uk Tiffany pieces abound. How can these online shops offer Tiffany pendants at substantially lower prices? Any or all of the following reasons may have transpired: The main silver pendants store conducts end-of-season sales. Third party retail shops buy Tiffany bracelets stocks during these sales so that they can offer them at highly discounted rates the whole year round.
Added at: 2010-07-22 06:58

Kommentar von anti shoes:
Women about butt shoesfor accent and chic, buy MBT shoes clearance are their choice, while it does not fit her at the top of beat is genuinelyworkings for optioning men's exercise shoes. With the uniquely curved sole, MBT women's shoes on sale will make you walk more uprightly, so that your muscles are activated, and you will find your posture is improved. In general, leather MBT men's shoes the bottom of beef tendon. special foot MBT equipped with special form only buy MBT men's shoes Normal. Do not attending to aggrandize If you aloof do not acquisition in added cossack affiancing and such protection, but are planned for the ambler acquisitive capacity. MBT shoes sale pulse routine became the focus of the removal of several sandals rudiments. As all of our shoes are directly purchased from a leading shoe manufacturer in world, our customers can enjoy the premium quality anti shoe at very good prices.
Added at: 2010-07-30 11:06

Kommentar von Steelers Jersey:
Colts Jersey Bob Sanders Jersey Dallas Clark Jersey Jeff Saturday Jersey Steelers Jersey Ben Roethlisberger Jersey Hines Ward Jersey vikings Jerseys Brett Favre Jersey Adrian Peterson Jersey Marion Barber Jersey Miles Austin Jersey Johnny Unitas Jersey Peyton Manning Jersey Reggie Wayne Jersey James Harrison Jersey Troy Polamalu Jersey Willie Parker Jersey Sidney Rice Jerseyy Jared Allen Jersey Percy Harvin Jersey cowboys Jersey Tony Romo Jersey Dez Bryant Jersey Jeff Saturday Jersey Steelers Jersey vikings Jerseys Marion Barber Jersey
Added at: 2010-08-13 04:32

Kommentar von Christian Louboutin:
Christian Louboutin Christian Louboutin hermes birkin hermes birkin moncler moncler herve leger herve leger
Added at: 2010-08-19 05:17

Kommentar von Reebok:
One innovative technology employed in reebok zigtech shoes falls on the use of zig zag sole in the footbed. With the unique function of saving energy for your feet provided. There is something other than creativeness in reebok shoes that differ them from other brands of shoes. Reebok sticks to the designing concept of comfy-wearing, chic-appearance and decorative features.
Added at: 2010-09-04 04:44

Navigation

Einträge in dieser Kategorie

Excel

Differenz zwischen zwei Daten (Plural von Datum)