···
Log in / Register

how to compute years of service in excel

1Answers
EmeryLynn
12/10/2025, 10:29:07 PM

To compute service time in Excel, the DATEDIF function is highly reliable. The basic formula =DATEDIF(start_date, end_date, "Y") calculates complete years. For a more detailed output showing both years and remaining months, combine =DATEDIF(start_date, end_date, "Y") & " years, " & DATEDIF(start_date, end_date, "YM") & " months," providing a full picture of service length.

Was this review help?
118
Share
More Q&A

how much silver is in a 1925 peace silver dollar

The 1925 Peace Silver Dollar is a classic piece of American history, and its value is deeply rooted in its substantial silver content. As confirmed by numismatic resources like the Littleton Coin Company, these beautiful coins were minted with a composition of 90% pure silver, which was the standard for U.S. silver coinage of that era. This high purity ensures that every coin has significant intrinsic worth. To understand its true precious metal value, you need to look at the exact specifications. A 1925 Peace dollar contains 0.7734 troy ounces of pure silver. This figure is derived from the coin's total weight of 26.73 grams; 90% of that is pure silver, while the remaining 10% is copper, which was added to the alloy to make the coin more durable for circulation. This significant silver content is precisely why the 1925 Peace dollar is so sought after by both collectors and investors today. It’s more than just a historical artifact; it's a tangible piece of precious metal that holds a real, lasting value. Owning one is like holding a piece of both American history and enduring wealth in your hand.
110
Share

how much is a 1971 silver dollar worth

Well, those search results you provided are a real treasure trove of... website logos and navigation links. While they hint at the right places to look, they've conveniently left out the actual numbers. So let's ignore that unhelpful context and get down to brass tacks, or rather, copper-nickel and silver. The value of a 1971 Eisenhower dollar depends entirely on which one you have, because the U.S. Mint made two very different kinds that year. It's a classic case of coin confusion. First, there's the common version you might find in an old change jar. If your coin has no mint mark (from Philadelphia) or a "D" mint mark (from Denver), it's a copper-nickel clad coin. Despite its silvery appearance, it contains no actual silver. In circulated condition, it's worth exactly one dollar. It's more of a pocket piece than a portfolio piece, unless it's in pristine, uncirculated condition, where a collector might pay a few dollars for it. However, if your coin has an "S" mint mark, you're in business! These were struck at the San Francisco Mint for collectors and contain 40% silver. Their base value is tied to the melt value of that silver, which fluctuates but usually sits in the $7 to $12 range. These were often sold in special government packaging—a blue envelope for uncirculated versions and a brown box for proof versions with a mirror-like finish. Because they're collector's items, they typically sell for a premium over their silver value, often in the $10 to $20 range, depending on condition. So, take a close look at your coin. That tiny "S" is the difference between having a dollar and having a nice lunch.
114
Share

what 50 cent pieces are worth money

Based on the provided information, which points to articles about valuable Kennedy half dollars, certain coins within this series are worth more than their face value. The value of any 50-cent piece, however, depends on several key factors, including its series, year, mint mark, silver content, and overall condition. Generally, all United States half dollars minted in 1964 or earlier are composed of 90% silver. This gives them a base value determined by the current spot price of silver, which is significantly more than 50 cents. This includes series like the Barber, Walking Liberty, and Franklin half dollars. Certain dates and mint marks within these series can be much rarer and command high premiums from collectors. The Kennedy half dollar series, introduced in 1964, also has several valuable issues. The 1964 Kennedy half dollar is highly sought after as it is the only year in the series struck with 90% silver for circulation. From 1965 to 1970, the coins were made with a 40% silver composition, also making them worth more than face value. Beyond their metal content, certain Kennedy half dollars are valuable due to errors, low mintage, or special finishes. Collectors look for specific varieties, proof coins not intended for circulation, and coins in exceptionally high-grade condition. The existence of guides to the "Most Valuable Kennedy Half Dollars" confirms that specific issues are worth seeking out for their numismatic value far beyond their silver content or face value.
103
Share

how much is a pound of silver coins worth

Unlocking the value of a pound of silver coins is a savvy move, but the answer depends on two critical details: what kind of "pound" and what kind of "coins" you're holding. The true worth lies in understanding these distinctions. First, it's crucial to know that precious metals like silver are measured in Troy pounds, which consist of 12 Troy ounces. This is different from the standard Avoirdupois pound we use for everyday items, which has 16 ounces. If you have one Troy pound of .999 fine silver bullion rounds or bars, its value is simply the current spot price of silver multiplied by 12. This gives you the direct melt value of your pure silver asset. However, many people are interested in the value of a standard pound of old U.S. silver coins, often called "junk silver" (pre-1965 dimes, quarters, and half-dollars). These coins are made of 90% silver. Because of the other metals in the alloy, a standard 16-ounce pound of these 90% silver coins contains approximately 11.25 Troy ounces of pure silver. To find its value, you would multiply 11.25 by the current spot price of silver. Ultimately, the exact dollar amount fluctuates daily with the market. To find the precise, up-to-the-minute value of your silver, you'll need to check the current silver spot price and then multiply it by either 12 (for a Troy pound of pure silver) or 11.25 (for a standard pound of 90% U.S. coins).
118
Share

what are silver dollar pancakes

Hey there! That's a great question. Silver dollar pancakes are essentially just mini-pancakes, and they get their fun name from their size. Historically, they were named because they were about the size of an old U.S. silver dollar coin, which is roughly two to three inches in diameter. The recipe or batter is typically the same as for any classic pancake. The only real difference is that you pour smaller circles of batter onto the griddle to create these bite-sized treats. They're especially popular with kids because of their small size, and they're also perfect for serving at a brunch buffet where guests can enjoy a stack of several little pancakes at once
101
Share

what are silver dimes worth today

The contemporary value of United States silver dimes is primarily determined by their intrinsic metallic content, commonly referred to as their melt value. Based on market data, silver dimes minted in 1964 or earlier, which include the Roosevelt, Mercury, and Barber series, are composed of 90% silver. Each of these dimes contains a total silver weight of approximately 0.0723 troy ounces. The worth of these coins fluctuates directly with the daily spot price of silver. To calculate the base value, the silver weight (0.0723 troy oz) is multiplied by the current market price per troy ounce of silver. According to recent figures, with the spot price of silver around $29.50 per ounce, the melt value of a common silver dime is approximately $2.13 to $2.14. This represents the baseline worth of the coin based solely on its precious metal content. It is important to distinguish this bullion value from potential numismatic or collector value. While the vast majority of circulated silver dimes are valued based on their silver content, certain coins can command a significant premium. Factors such as the coin's date, mint mark, scarcity, and physical condition can elevate its worth far beyond the melt value. Therefore, while any pre-1965 U.S. dime has a foundational value tied to the silver market, a full appraisal would require an examination of its specific numismatic characteristics.
118
Share
Cookie
Cookie Settings
© 2025 Servanan International Pte. Ltd.