finding how many months are there between months

Key Takeaways

hi friends this is rajinikanth excel guru and few days before i asked these type of queries but only a few people have tried with so many methods and they are right but i like to show you in a different method and so many people have called to it's a really amazing query so how can we find the total and total months between june to august that is june july august how can you find it so here i will explain you how to do that one okay see first of all i'll explain you suppose here it come month is there like january okay done only done here i'll give you january okay so you have to month number first of all you have to get month number so some people will try directly like this but it will not work so what i'll do here instead of doing that that i add only one so it will consider as a first off done so first off john is considered as a month and date so automatically it will pick up that month that is one if i drag this formula down also it will work it may be any three letters or three letters or more than three letters okay so here i am doing this type of uh format or a formula to find out how many are there between how many months are there between june to august okay first of all we have to take it out june from this right you have to pick it out june from that see here however i do left off this comma we don't know because here d u n is june and j you and june and api so the delimiter is hyphen so you have to find the position of hyphen this is position of hyphen search and minus one see why i taken minus one first of all i'll find how many characters are there f9 see one two three four if i if i did not do the minus one it will take five but i need four see first of all control enter double click april june august everything will come right if i enter like uh apple f2 il okay still now you understood now we have to count how many months how or how many months are there between june to august okay so what i'll do here i have to simply add month of one ampersand and so it will pick up six okay double click right we got the month number again you have to find the august see how i'll do august one the mid i'll use the mid function here and search of same hyphen and this one plus one and here is how many characters do you need after the hyphen i can't guess because august is six meters the length of the characters is six letters but it may be three letters four letters we can't guess it so for that reason i am taking 255 all the characters after the hyphen i need okay how many how many it may be it may be two four ten enemy but all the characters after the hyphen f9c august control enter double click see now i'll move little bit here or i delete i delete this one now again i'll use the month function over here month of one ampersand can day okay enter so it will pick up the month eight right now we have to find how many are there between this june july august 3 totally three months are including june i'm telling including june to august june july august so three months so what i'll do here row of indirect this one ampersand this one ampersand this one f9 okay i forgot to close another paranthesis here yes f9 678 right so what i'll use here count the numbers how many numbers are there so if i press enter it will give you the wrong answer so it's an array function you have to use ctrl shift and enter here i did with the helper column but without helper column how you will do first of all copy this whole formula from here ctrl c escape don't include equal sign and place it over here ctrl v which one i did let me check okay i did which one i did um first two and six one you have to do okay now this one you have to do eight one okay f2 whole formula ctrl c escape f2 double click ctrl v okay and use ctrl shift and enter that's it okay i think somewhere went wrong june to december seven months including june i'm telling apple to other statements august 2 december august september october november december 5 months okay now coming to here how to find the employee date of birth by the month numbers if it is dead somebody is there if i change may december is uh more than three characters made only three characters so it may be four characters three characters four characters we don't know so we have to find the date of birth of the employee so is equal to same procedure month by using vlookup ampersand before that i will do here okay here only better month of one ampersand this one so it will give you the number right so by using this number we can use vlookup we look up of this month date comma f4 comma two comma zero it's a normal function june 6 mn right and if you have any more doubts please let me know in the comment box and if anybody wants to join in my excel online session telegram group they can join okay please mention uh if anybody wants to join just let me know in the comment box so that i will send the link to that person and thank you guys thanks for your support have a nice day please like share and subscribe with its kind request