Answer the question
In order to leave comments, you need to log in
How to calculate the length of service in different companies in excel?
I can’t understand how to calculate correctly or the logic of the formula chtoli ...
I have data on how much experience a person has in total, in the format X years Y months N days
is the date of admission to our company,
you need to know how much experience he has in our company and how much total/full experience
, that's what I made, but I don't understand how to connect XYN with the experience that we already have
https://drive.google.com/file/d/1UvQC9Wiw370rT4o84...
Answer the question
In order to leave comments, you need to log in
X*365 + Y*30 + N - length of service before working in the company in days
Z - length of service in the company in days = DAYS(Current_date;Date_of_acceptance)
X*365 + Y*30 + N + Z - total length of service in days
Years = INTEGER(Days/365)
Months = INTEGER((Days-Years*365)/30)
Days = Days - Years*365 - Months*30
Collect date using
for VBA DateSerial
for EXCEL DATE
since. dates are represented by numbers, then you can safely subtract and add them,
i.e.
Start Date of Experience = Today's Date - DateSerial (X, Y, N)
Further simple arithmetic
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question