How To Add Dates

Table of contents:

How To Add Dates
How To Add Dates

Video: How To Add Dates

Video: How To Add Dates
Video: How to Add Days to Dates in Excel 2024, November
Anonim

Adding dates is a simple arithmetic operation, however it has its own peculiarities. If you need to calculate the exact number of months, days and years, you can do it yourself or use special programs.

How to add dates
How to add dates

Necessary

  • - the calendar;
  • - calculator;
  • - program for calculating the length of service.

Instructions

Step 1

When calculating, you need to take into account several factors: the maximum number of days in a month is thirty-one, and months are twelve, and the shortest of them is February. Also, remember that in a leap year that occurs every three years, there are twenty-nine days in February, not twenty-eight.

Step 2

There is also a certain cyclicality, according to which there are always thirty-one days in December, January and August, and in the remaining months (except February) the number of days alternates. In March - thirty-one days, in April - thirty, in May again thirty-one, and so on. In order not to get confused, take the calendar for the period (s) of time you need. You can use the calendar on your computer: it starts counting from 1980, and you can clearly see how many days there were in a given month.

Step 3

Start adding dates from days. If the number of days for the selected month is equal to or greater than the allowed value, convert the days to months. So, if you need to add the dates 2012-01-02 and 2012-01-03, the end result is 0 days and 1 month, not 29 days. Then add the months using the same principle. If the total is more than twelve, convert the value to years.

Step 4

Adding dates by hand takes care and concentration. If you want to save time and effort, it is better to use special computer programs. As a rule, they are used to calculate seniority. There are many versions of such programs; they can be distributed either separately or be built into accounting or personnel programs. Enter in the search engine a query from the keys "experience", "work", "calculation" and find the utility that suits you.

Step 5

The interface of such applications is quite simple: enter in the first field the date from which the calculation should begin, in the next field (s) - the end or intermediate date. Click on the button "Calculate" ("Show experience"), and the program will give a ready answer with the number of days, months and years.

Recommended: