I don't understand why you used row function at 4.00 mts..What's is the problem in giving column no.2 in that vlookup function..Pls explain Nabil...Your tutorial is awesome
yes. why he didn't use the column no. 2. instead of the range $E$1:E2, which has no significance in the table and which is better? anyway, tutorial is awesome.
Yes I got it
I want this video
Amazing sir 👌👌👌👌👌
My favourite video
This is indeed a wonderful lecture. I love it. Thank you Nabil.
Thanks a lot for the explanation and also the file on cloud. I was trying to do exactly these calculations so that file saved me a lot of time too
Thank you for making these videos!
exactly what I needed... thanks a lot for sharing
Glad it helped!
الف شكر على المجهود ، محاضرة ممتازة جدا ومفيدة جدا جدا جزاك الله خيرا
الف شكر يا محمد ...تابع القناة
Excellent. Exactly what I was looking for.
Thank you and glad you found it useful
This is awesome! Just what I was looking for, thank you.
Good...!! It's very useful. Thank you.
Excellent.
I don't understand why you used row function at 4.00 mts..What's is the problem in giving column no.2 in that vlookup function..Pls explain Nabil...Your tutorial is awesome
yes. why he didn't use the column no. 2. instead of the range $E$1:E2, which has no significance in the table and which is better? anyway, tutorial is awesome.
Honestly, I have to watch the video to answer your question, I created this one over 2 years ago...
Anyway thanks for the interaction
You might be correct my friend... there is always a better way to do things
MD prone to wrong calculation. How to calculate days differently? How to calculate elapsed Y, M, D, H:MM ?? Thanks Nabil, great teacher!
GREAT !! Only EXCEL won't calculate before 1900. So my grandpa born in 1885 won't give an answer. Do you know how to solve this ??
In VBA day one is the first of January 1600
@@Officeinstructor How to do this ... macro ??
How did you get the spaces between the dates?
Type the space in double quotation and of course use the joining operator of Excel "&"
=Datedif(Start date,end date,"y")&-Datedif(Start date,end date,"ym")&-Datedif(Start date,end date,"md")
Ye Wala formula lgao or age aik cell main pao
sir your mind is very fast
i apologize if it was too fast but you can always pause, rewind and replay
@@Officeinstructor haa haa, ok sir zee i am learn many things from u, but i am not find and placed any job, i am increase my skill for better