Jobs Find List

Categories


Location

Calculate Length of Employment in Excel

Microsoft Excel is a number-crunching program that can effortlessly calculate the length of employment. This calculation usually involves just two pieces of data -- the dates that the employee began and ended working for the organization. However, date-based information commonly includes letters when expressing the month, such as "January" and "December." Entering words in a spreadsheet can hamper your attempts at arriving at an accurate numerical calculation of the length of employment. If this is your predicament, you can take two simplified approaches to doing the math on these dates, and eliminate the problems of inputting letters.

Formula

Launch the Microsoft Excel application. Open a blank worksheet by pressing the "Ctrl" and "N" keys on the keyboard. Alternatively, click the "New" icon at the top of the window, which resembles a blank sheet of paper.

Click on the cell at address "A1." Type the start date of employment similar to one of the following formats: "01-2011" or "01-15-2011." Press "Enter" to deactivate the cell.

Click on the cell at address "B1." Type the end date of employment, such as "04-2011" or "04-15-2011." Press "Enter."

Click on the cell at address "C1." Type the following formula: " =B1-A1 ." Press "Enter." Cell "C1" shows the subtraction of the starting date of employment from the ending date of employment, in days. Continuing with the example dates shown in previous steps, the formula works out in the following manner: (04-2011) - (01-2011) = 90 days; (04-15-2011) - (01-15-2011) = 90 days.

Function

Open a blank worksheet in Microsoft Excel.

Type the starting employment date in cell "A1." Press "Enter."

Type the ending employment date in cell "B1." Press "Enter."

Type the following function in cell "C1": " =DAYS360(B1,A1)." Press "Enter." The value in cell C1 represents the number of days of employment from start to end.



Tips to Find a Job from Millions of Job Listings Online in United States

Find Senior Citizen Jobs

If you think senior citizen jobs are hard to find, think again. There are many employers looking specifically for older, mature employees. As more and more baby boomers reach retirement age, more and more older people over 50 are looking for employment. A lot of employers like to hire seniors becaus ...

How Long Do Results From Pre Employment Drug Tests Take?

Why Drug Test? Drug testing has become an important safety issue in the workplace for Human Resources and Safety professionals. The majority of Fortune 500 companies do drug testing. They test simply to limit the amount of drug abuse in the workplace. Drug abuse affects company profits with absente ...

What Job Would I Get With a Degree in Applied Chemistry?

The study of applied chemistry can lead students into a wide variety of careers due to the fact that chemistry is an integral part of life and technology. Students will obtain knowledge not only of the elements of chemistry, but also how it works with other scientific fields. They will also learn ab ...

Media Researcher Job Description

A career as a media researcher opens a window into how television, radio, movies and the Internet help the public make decisions. Many companies need media researchers to explore the best use of new communication opportunities, especially online.Job Description Media researchers find information an ...

General Clerk III Job Description

There are several jobs that fall under the classification of general clerk. The business world has organized the required workload of a general clerk into levels, with each higher category of general clerk having a broader range of required knowledge and duties. The general clerk III position carrie ...

A Job Description of a Front Desk Attendant

A front desk attendant performs clerical duties and greets customers for a company. Front desk attendants work in nearly every type of industry and handle multiple tasks. Besides greeting customers or clients who enter an establishment, front desk attendants answer phones, take messages, forward mai ...

Sales Personnel Job Description

“Sales personnel” refers to those who works as part of the sales team either in a retail store, call center or individually from home. Sales personnel are employed to sell to other businesses or to individual consumers. Working in sales can be demanding or stressful, as much of the role ...

Make Small Talk During a Job Interview

The purpose of small talk is to get both parties to relax. When somebody walks into a job interview, the tension is usually so high that it becomes difficult for both people in the room to get a good sense of what the other is thinking. Small talk, however, is almost an art. There are dos and don'ts ...

Do I Have to Pay for an Unfinished Construction Job?

Even when a contractor abandons a project, a homeowner must pay for all properly performed work. A homeowner is entitled to withhold an amount sufficient to find a replacement contractor in that situation. Care should be taken when withholding payment, though, as contractors have many tools at their ...

Drug Detox Specialist Career

Drug addiction is a perpetual problem in America. The drug detox specialist is trained and ready to help those addicts who are wanting to break the habit.Definition A drug detox specialist interviews potential clients to determine their eligibility for treatment programs. They also compose summarie ...

Types of Veterinary Jobs

The field of veterinary medicine offers many different types of jobs. Veterinarians don't just take care of pets; they also care for zoo animals and farm livestock. There are many related jobs, including such titles as veterinary assistant, veterinary technician or technologist, and animal care and ...

Sanitation Supervisor Job Description

A sanitation supervisor is a professional found within the food manufacturing industry. This professional oversees all initiatives related to food safety and hygiene. Coordinating all cleaning and vermin control procedures, a sanitation supervisor ensures that the facility is in compliance with all ...

Direct Care Staff Job Description

As the job title suggests, direct care staff members are the people who work directly with clients. In many cases, those clients are elderly, physically impaired or mentally impaired individuals who are not able to care for all of their needs on their own. This can be a demanding job, and one that r ...

What Jobs Can You Do With an Associate Degree in English?

An associate's degree in English represents a well-rounded background in general education with an emphasis on reading and writing. Your degree, coupled with good communication and organizational skills, qualifies you for a variety of entry-level positions in many industries, including business offi ...

Network Engineer Job Description

Modern day businesses run on information technology. E-commerce allows the buying and selling of products and services online. Computer networks allow rapid communication inside and outside an office. A network engineer designs, installs and supports computer systems inside an organization. As infor ...