Question description:
This user has given permission to use the problem statement for this
blog.
I want to use the IF function to find out the Vintage of an employee from Date of joining
Solved by V. D. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
05/02/2018 - 02:01
Hello! Welcome to Excel Chat.
Excelchat Expert
05/02/2018 - 02:02
How may I help you today?
User
05/02/2018 - 02:02
Hi
User
05/02/2018 - 02:02
I want to know if the date of joining of an employee is 12th Jan 2016 then as on date what will be his total vintage in the organisation?
User
05/02/2018 - 02:03
what formula should I type ..
Excelchat Expert
05/02/2018 - 02:03
Vintage is equal to the length of the service till date? Let me know if my understanding is corrrect.
User
05/02/2018 - 02:03
yes
Excelchat Expert
05/02/2018 - 02:04
Ok. Let me work out a formula for you then.
User
05/02/2018 - 02:04
please show me in the spread sheet with few data
Excelchat Expert
05/02/2018 - 02:05
Sure. In what units, you would like to get the result?
User
05/02/2018 - 02:06
In number of days
Excelchat Expert
05/02/2018 - 02:06
Ok.
User
05/02/2018 - 02:06
I also need to know how do i spolit that in 0-6 months : 6-12 months etc
Excelchat Expert
05/02/2018 - 02:07
Ok. Just give me a moment to work on your problem.
Excelchat Expert
05/02/2018 - 02:08
Please see the worksheet.
Excelchat Expert
05/02/2018 - 02:09
In cell A1, there is the first date, i.e. date of joining.
Excelchat Expert
05/02/2018 - 02:09
In cell B2, is today's date.
User
05/02/2018 - 02:09
how do i split it into 0-6 mths, 6-9 months and 9-12 months
User
05/02/2018 - 02:09
need to know the IF and ISERROR functions
Excelchat Expert
05/02/2018 - 02:09
Ok, now you want to categorize in different categories?
User
05/02/2018 - 02:10
yes
Excelchat Expert
05/02/2018 - 02:10
Then let's use the month diff, then
User
05/02/2018 - 02:10
ok
Excelchat Expert
05/02/2018 - 02:10
In cell C2, you can see 24 now.
Excelchat Expert
05/02/2018 - 02:10
This is 24 month that is the difference between two dates.
Excelchat Expert
05/02/2018 - 02:11
Now we will use this further.
Excelchat Expert
05/02/2018 - 02:13
Give me a moment to improve it further.
Excelchat Expert
05/02/2018 - 02:16
Sorry to keep you waiting.
Excelchat Expert
05/02/2018 - 02:16
I have updated the formula in D1.
Excelchat Expert
05/02/2018 - 02:16
Please verify the solution.
User
05/02/2018 - 02:18
Give me few mins to verify ..
Excelchat Expert
05/02/2018 - 02:18
Sure.
Excelchat Expert
05/02/2018 - 02:18
After that, I will explain the solution.
User
05/02/2018 - 02:20
Can you explain me Cl D formula please
Excelchat Expert
05/02/2018 - 02:20
Ok.
Excelchat Expert
05/02/2018 - 02:21
In cell C1, it's a simple Date difference formula, where 3 inputs are required, first date, second date, and the unit in which we want to see the results.
Excelchat Expert
05/02/2018 - 02:21
=DateDif(A1, B1, "M")
User
05/02/2018 - 02:22
ok understood the Cl C
Excelchat Expert
05/02/2018 - 02:22
here M is for month. you can use "Y" for year, "D" for days. You can also use combination of them like "YMD" or "YM" or "MD" etc.
Excelchat Expert
05/02/2018 - 02:22
Great!
Excelchat Expert
05/02/2018 - 02:23
In D1, it's a nested IF formula.
Excelchat Expert
05/02/2018 - 02:24
IF also need 3 inputs, 1 - condition that is to be checked, 2 - Result if given condition is true, 3 - Result if given condition is false (optional).
Excelchat Expert
05/02/2018 - 02:25
So I am checking C1 for a value, and if that condition is true, give me the first message, if that condition is false, check again C1 for a new value. And so on.
Excelchat Expert
05/02/2018 - 02:25
Here I used, IF in another IF 2 times more.
Excelchat Expert
05/02/2018 - 02:26
Excel has a limit that you can put upto 8 IF inside an IF.
Excelchat Expert
05/02/2018 - 02:26
I hope I was able to explain the solution, please let me know if you have any question.
User
05/02/2018 - 02:28
thx
User
05/02/2018 - 02:29
where can i find teh list of formulas if i dont know
User
05/02/2018 - 02:29
which formula to apply
Excelchat Expert
05/02/2018 - 02:29
You can Google for Excel formulas and Excel help.
User
05/02/2018 - 02:30
can u suggest a link .. also do you guys provide class room trainings ?
Excelchat Expert
05/02/2018 - 02:30
Which formula to apply is dependent on question.
Excelchat Expert
05/02/2018 - 02:30
I am sorry, there is no class room training for now.
Excelchat Expert
05/02/2018 - 02:31
I am glad that I could help you today. Hope to see here yo soon.
User
05/02/2018 - 02:31
so if I enroll with Got IT Pro ..can I get assistance for the formulas I need
Excelchat Expert
05/02/2018 - 02:31
Yes. For each question, you can start a new session and an expert will be there for help.
Excelchat Expert
05/02/2018 - 02:35
Have a nice day ahead. Bye!
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.