···
Log in / Register

how to calculate years of service in excel

1Answers
MacGage
12/10/2025, 10:15:00 PM

In Excel, the most accurate way to calculate years of service is by using the DATEDIF function. To get only the total full years, you can use =DATEDIF(start_date, end_date, "Y"). If you need a more detailed result, such as showing both years and months, you can apply =DATEDIF(start_date, end_date, "Y") & " years, " & DATEDIF(start_date, end_date, "YM") & " months".

Was this review help?
102
Share
More Q&A

what is a silver dollar worth in 2024

When considering the value of a silver dollar in 2024, it's essential to understand that not all silver dollars are created equal. The answer truly shines when we look at the modern pinnacle of silver coinage, the American Silver Eagle. The value you can expect depends entirely on whether you have a standard bullion coin or a magnificent collector's edition. For the discerning collector, the 2024-W American Silver Eagle Proof coin is an exceptional piece to acquire. These coins represent the height of the U.S. Mint's artistry. Struck at the West Point Mint in one full ounce of 99.9% pure silver, this coin is a true treasure. It features breathtaking mirror-like surfaces that make its classic Liberty Walking design stand out. Because of its superb quality and high demand among collectors, a 2024-W Proof Silver Eagle is valued at a significant premium, with retailers like Littleton Coin Company offering it for $175.00. This collector's value is distinct from the value of a standard, non-proof 2024 American Silver Eagle. The value of a standard bullion Silver Eagle is tied more closely to the fluctuating spot price of silver, plus a smaller premium. While still a fantastic investment in pure silver, its value is based on its precious metal content rather than its numismatic rarity and beauty. So, while one 2024 silver dollar is a solid store of wealth, another is a high-end collectible worth many times its weight in silver.
116
Share

what coins are silver value

Hey there! That's a great question, and it's always fun to look for treasure in your pocket change. Based on the information provided, the key to a U.S. coin having silver value is almost always its mint date. A good rule of thumb is that most U.S. dimes, quarters, half dollars, and dollar coins made in 1964 or earlier are 90% silver. This includes a lot of different coins, such as Morgan and Peace dollars, Washington quarters, Franklin half dollars, and Mercury dimes. If you find any of these coins with a date of 1964 or an earlier year, it's worth more than its face value because of the silver it contains. There are a couple of notable exceptions to keep an eye out for as well. Kennedy half dollars that were minted between 1965 and 1970 aren't 90% silver, but they are still valuable as they contain 40% silver. Another special case is the "War Nickel." Jefferson nickels made between 1942 and 1945 contain 35% silver. You can easily spot these because they have a large mint mark (P, D, or S) on the back, right above Monticello. So, when you're checking your coins, the date is the most important thing to look for! The actual melt value of these coins will fluctuate with the daily market price of silver.
112
Share

where do i get rolls of quarters

Ah, the eternal quest for the quarter, the laundry day dragon that must be slain. Fear not, for obtaining these shiny little discs of monetary power is easier than you think. Your primary and most civilized option is, of course, a bank. Walk up to any teller with a crisp $10 bill and ask for a roll of quarters. It’s literally their job to trade you paper for metal. While some banks might get a bit particular if you don't have an account, most are happy to oblige the desperate and coinless. If a trip to the bank feels too much like an official adult errand, your next best bet is the customer service desk at a large grocery store. They are the unsung heroes of the change game, often equipped with rolls ready for the taking. Pharmacies and even some convenience stores can also be a source, though you might get a polite refusal if their own till is running low. It's always worth a shot to ask nicely. For a more direct, in-the-wild approach, seek out the natural habitat of the quarter: laundromats, car washes, and arcades. Their change machines are built for this very purpose, greedily accepting your bills and spitting out a clattering cascade of coins. You may not get a neat paper-wrapped roll, but you will get the quarters you need to finally wash that mounting pile of clothes. Happy laundering
104
Share

who was on the silver dollar before eisenhower

Believe it or not, the story of the dollar coin before Dwight D. Eisenhower is the story of Lady Liberty. For decades, the dollar didn't feature a president at all, but rather this powerful and symbolic figure. The coin struck immediately before the Eisenhower dollar was the iconic Peace dollar. This beautiful coin, minted from 1921 until 1935, featured a distinctive profile of the goddess Liberty on its front. Its production marked the end of an era, as no new dollar coins were issued for circulation for a very long time after 1935. When the U.S. Mint revived the dollar coin in 1971 with Eisenhower's profile, it was the first one released to the public in over 35 years. Just before the Peace dollar, another famous coin, the Morgan dollar, also circulated. Minted from 1878 to 1921, it too featured a classic depiction of Lady Liberty. So, while Eisenhower was the first president to be honored on a modern, circulating dollar, his predecessor wasn't another person but the timeless symbol of American freedom itself.
116
Share

how much is 1 oz of silver worth in canadian dollars

Ah, the million-dollar question! Or, more accurately, the somewhere-around-forty-dollar question, depending on the day. Asking for the price of an ounce of silver in Canadian dollars is like asking about the weather in Toronto; it’s guaranteed to be different tomorrow, and probably changed five times while you were asking. The provided snippets from GoldBroker and XE.com are tantalizingly close to an answer. They're like a treasure map that points to the island but doesn't have the "X" marking the spot. They confirm you're looking in the right place, but don't give away the prize itself. That's because the value of silver is based on its "spot price," which is the live market price for one troy ounce. This price is in constant flux, wiggling up and down based on global supply, demand, and investor sentiment. To give you a number you can hang your hat on for at least a few minutes, as of my last update, one troy ounce of silver is worth approximately $40 CAD. However, I strongly advise you to treat that number like a carton of milk and check the expiry date. For the most current, up-to-the-second price, you'll want to check a live chart on a site like the ones you found. That way, you're getting the price as it is right now, not as it was a few moments ago.
105
Share

what is the value of a silver dollar certificate

The provided context is insufficient to answer the question. Based on general knowledge, the value of a silver dollar certificate is determined by its condition, series year, and rarity, rather than its face value or its former silver backing. While these notes are still considered legal tender for their face amount, their primary value is as a collectible. The ability to redeem silver certificates for physical silver was discontinued by the U.S. government in 1968. Today, their worth is based on what collectors are willing to pay, which depends on several key factors. The most common silver certificates, such as the 1935 and 1957 series in circulated condition, are typically worth only slightly more than face value, often ranging from $1.50 to $5. However, notes in crisp, uncirculated condition will command a higher price. Older series, such as those from 1899 or 1923, are rarer and can be worth significantly more, from $30 to several hundred dollars depending on their grade. For an accurate valuation, a specific silver certificate should be examined by a professional currency appraiser or a reputable coin and paper money dealer. They can assess its precise condition, identify its series, and check for unique characteristics like star notes (replacement notes) that can greatly increase its value to collectors.
109
Share
Cookie
Cookie Settings
© 2025 Servanan International Pte. Ltd.