Learn Satish Sir courses with Certificate Download Course App : bit.ly/3BWfQVa Course Website :bit.ly/skill_course Course Features : ✅ सभी Videos सरल हिंदी भाषा में ⬇ Download Video in APP ✅ Basic to Advance Courses ✅ Practice Files (Yes) ✅ PDF Shortcuts ✅ Course Completion Certificate ✅ Instant Access ✅ Watch on Desktop : skillcourse.in/
It can solved through lookup formula.. 1st u will have to make a 2 column table for quarters in excel.... In 1 column 1 month in 2nd column quarter. 1| quarter 4 2| quarter 4 3|quarter 4 4|quarter 1..so on Now formula will be.... Lookup(month(serial number), lookup vector)) Serial no. Will be date in excel, lookup vector will be the above table which we made for quarters.. Please do fix "f4" the table...
Thanks Sir, It's very useful for me. Sir, i've got a problem i.e. if i can type in A1 cell date 05/04/2015 now i got directely in B1 cell 31/03/2016 (in the same way in A1 cell i type any date between 01/04/2015 to 31/03/2016)
Another way, use formula -- month(serial number), serial number is where you have date in excel data... Result will be 1 for jan, 2 for feb.. So on, now ctrl+1 go to custom, search "quarter "0, in look up list, select and then OK..
R. Sir, Very interesting, simple way to describe thanks for sharing this.i am fan of your channel. I suggest you please make a video that when we click in a cell whole row and column line will be highlighted.it may helpful in the maintain of large data correctly. Thank Manmohan.
i have a date of 30-09-2013 and I m trying this but its getting 9 only will you provide me a practice file of this video so that I can see your way or in this video if you shows us another column date formula then it would be very help full pls reply my answer if you are there
i tried but when there is 30-11-2013 then was not changing it was taking as 6 while all the data got changed even you can say that 4th qrt was not working on this formula
Sir we can use if(month()greater equal to 9 then 4 quarter if(month()greater equal to 6 then 3 quarter if month()greater equal to 4 then 2 quarter month()greater equal to 1 then 1 quarter )))
PAWAR SIR JAR AAPNA CEILINGG ASHA PRAKARE USE KARTOY =CEILING(10.2,0.5) TAR RESULT YETO 10.5 AND =ROUNDUP(10.2,0.5) USE KARTO TAR RESULT YETO 11 MEANS DECIMAL PLACES VARTI CEILING WORK KARTO ANI MAJE VIDEO PAHILYA BADDAL DANYAVAD SIR
मला excel चा formula सांगावे please. A column मध्ये टास्क आहेत column b मध्ये टास्क करायची आहेत त्याची frequency आहे जसे weekly,forthnight, monthly, half yearly, yearly. Column c मध्ये तारखेche number आहेत 1 ते 31 पर्यंत. Ani Column d pasun q paryant महिने आहेत. मला असा formula पाहिजे की जेव्हा मी Column c मध्ये 15 number टाकला Ani Column b मध्ये monthly सिलेक्ट केले dropdown list madhun नंतर Column d pasun q paryant सर्व महिन्यात तारीख dd-mm-yy मध्ये दिसली पाहिजे .समजा column c मध्ये आपण 31 टाकली तर ज्या 31 तारीख येते फक्त त्या महिन्यात तारीख सोसली पाहिजे.जर मी Column b मध्ये quartly केले तर tarikh फक्त quartly महिन्यात दिसली पाहिजेत. जर मी half yearly सिलेक्ट केले तर फक्त दर सहा महिन्यात तारीख दिसली पाहिजे .formula सापडणे प्लीज.
I think it is not proper answer to that question or u didn't understood the question properly. Even i m looking for any formula which can help me out. Sir plz take my example to explain. I m providing Annual maintenance contract to consumer durables. The can start on any date as per customer, but he pays me as per quarter ie. For 3 months. If AMC start on jan 1 then it is very easy to calculate start and end date of quarters in that year like 1st quarter start 1 Jan to 31st mar, then 2nd quarter from 1st April to 30 th June...And ao on, but problem arise when if AMC start on any other dates, any dates eg, 7, 12, 15, 19, 23, etc of any month, then it will be very difficult to calculate start and end dates of quarters. So it is very helpful to me if you provide me proper solution. Thanks in advance.
Learn Satish Sir courses with Certificate
Download Course App : bit.ly/3BWfQVa
Course Website :bit.ly/skill_course
Course Features :
✅ सभी Videos सरल हिंदी भाषा में
⬇ Download Video in APP
✅ Basic to Advance Courses
✅ Practice Files (Yes)
✅ PDF Shortcuts
✅ Course Completion Certificate
✅ Instant Access
✅ Watch on Desktop : skillcourse.in/
vaise app ka video deekh kr mai bahut kuch sikh gaya hu
i love your sir ji
Very informative. Thanks for teaching.
Thanks sir treding ke liye usful hain
Very nice explaining
Nice formula and video sir
Thanks sir
Nice video and information sirji
thanks sir thanks a lot for watching
Jabardast...
thanks sunil ji thanks a lot for watching this video
Wa sir
thanks brother for watching this video..........
Very nice video sir
Thanks Akshay watching my video....
good job Satish
THANKS A LOT SAHIL JI FOR WATCHING MY VIDEO....
nice video sir
Thanks pratikasha watching my video..Share with ur frnds...
THANK YOU VERY MUCH ..SATISH JEE .. NICE FORMULA..
THANKS BANWARI SIR FOR WATCHING MY VIDEOS AND GIVING ME A CHANGE TO WORK ON SUCH A NICE QUERY
THANKS.. EXPECT SOME MORE NICE TUTORIALS
Hmmm nice one
Thanks Jacky ji watching my video...Plz share with ur Frnds..
Learn More sir ji sure
Awesome sirji
thanks khemraji thanks a lot for watching and i got the solution on your vlookup query will share with you soon
10nks satish ji ur always rply
Beautiful
Thanks Mohammed bhai watching my video....
Very very good sir....
👍👍👍
THANKS AMOL BHAI THANKS A LOT FOR WATCHING
Amazing Shatishbhai excel is like a cave there's so much to learn .Thank You
Thanks mooseji thanks a lot for watching
Sir, mi aapanas lienst function vishayi vicharale hote sir
YES SIR I WILL SEE AND DEFINITELY TELL YOU ABOUT THAT
How to calculate q1 month start with april
It can solved through lookup formula..
1st u will have to make a 2 column table for quarters in excel.... In 1 column 1 month in 2nd column quarter.
1| quarter 4
2| quarter 4
3|quarter 4
4|quarter 1..so on
Now formula will be.... Lookup(month(serial number), lookup vector))
Serial no. Will be date in excel, lookup vector will be the above table which we made for quarters.. Please do fix "f4" the table...
Thanks Sir, It's very useful for me. Sir, i've got a problem i.e. if i can type in A1 cell date 05/04/2015 now i got directely in B1 cell 31/03/2016 (in the same way in A1 cell i type any date between 01/04/2015 to 31/03/2016)
shirish ji tumcha problem mail kela tar bar hoil maja mail id - satishdhawale363@gmail.com
IF OR combination se ye solve ho sakta h ...i have done many times
Another way, use formula -- month(serial number), serial number is where you have date in excel data... Result will be 1 for jan, 2 for feb.. So on, now ctrl+1 go to custom, search "quarter "0, in look up list, select and then OK..
How to change years quarters and months in excel
R. Sir,
Very interesting, simple way to describe thanks for sharing this.i am fan of your channel.
I suggest you please make a video that when we click in a cell whole row and column line will be highlighted.it may helpful in the maintain of large data correctly.
Thank
Manmohan.
ok thats interesting logic i will work on it aapko jaldhi batata hun ji iske bareme
sir g computer ki screen pr koi text chlana h to kese chlaye
Instead Of That I Used =choose(month(cellno),1,1,1,2,2,2,3,3,3,4,4,4,) and the answer was there
i have a date of 30-09-2013 and I m trying this but its getting 9 only will you provide me a practice file of this video so that I can see your way or in this video if you shows us another column date formula then it would be very help full
pls reply my answer if you are there
i tried but when there is 30-11-2013 then was not changing it was taking as 6 while all the data got changed even you can say that 4th qrt was not working on this formula
Sir please outlook pe video banaona me apna mail outlook se send karta hu par vo outbox me hi rah jata he sent hota hi nahi please sovle my problem
How to set ending year is 31st march how to set 1st quarter from April Pls intimate
Sir we can use if(month()greater equal to 9 then 4 quarter if(month()greater equal to 6 then 3 quarter if month()greater equal to 4 then 2 quarter month()greater equal to 1 then 1 quarter )))
yes you are absolutely right we can do this with that method very good logic jitesh ji thanks for sharing
Learn More sir ji thanks very much
Sir plz explain the difference between Roundup and Ceiling function, bcoz someone sd me an another way ="Quarter "&ROUNDUP(MONTH(01/01/2017)/3,0) -
PAWAR SIR JAR AAPNA CEILINGG ASHA PRAKARE USE KARTOY =CEILING(10.2,0.5) TAR RESULT YETO 10.5 AND =ROUNDUP(10.2,0.5) USE KARTO TAR RESULT YETO 11 MEANS DECIMAL PLACES VARTI CEILING WORK KARTO ANI MAJE VIDEO PAHILYA BADDAL DANYAVAD SIR
Thnx for reply sir,we are grateful to you, i am a subscriber of ur challan i regular watch ur video
THANKS PAWARJI i really like to hearing from you about my video keep writing comments after watching it
मला excel चा formula सांगावे please.
A column मध्ये टास्क आहेत column b मध्ये टास्क करायची आहेत त्याची frequency आहे जसे weekly,forthnight, monthly, half yearly, yearly. Column c मध्ये तारखेche number आहेत 1 ते 31 पर्यंत. Ani Column d pasun q paryant महिने आहेत.
मला असा formula पाहिजे की जेव्हा मी Column c मध्ये 15 number टाकला Ani Column b मध्ये monthly सिलेक्ट केले dropdown list madhun नंतर Column d pasun q paryant सर्व महिन्यात तारीख dd-mm-yy मध्ये दिसली पाहिजे .समजा column c मध्ये आपण 31 टाकली तर ज्या 31 तारीख येते फक्त त्या महिन्यात तारीख सोसली पाहिजे.जर मी Column b मध्ये quartly केले तर tarikh फक्त quartly महिन्यात दिसली पाहिजेत. जर मी half yearly सिलेक्ट केले तर फक्त दर सहा महिन्यात तारीख दिसली पाहिजे .formula सापडणे प्लीज.
But hamare quarter to April se start hota h
Krishan Pal Singh i do it for u after some time
I think it is not proper answer to that question or u didn't understood the question properly. Even i m looking for any formula which can help me out. Sir plz take my example to explain. I m providing Annual maintenance contract to consumer durables. The can start on any date as per customer, but he pays me as per quarter ie. For 3 months. If AMC start on jan 1 then it is very easy to calculate start and end date of quarters in that year like 1st quarter start 1 Jan to 31st mar, then 2nd quarter from 1st April to 30 th June...And ao on, but problem arise when if AMC start on any other dates, any dates eg, 7, 12, 15, 19, 23, etc of any month, then it will be very difficult to calculate start and end dates of quarters. So it is very helpful to me if you provide me proper solution. Thanks in advance.
BUT SIR WHAT HAPPENED ABOUT MY "PPT" QUERY ..?
SIR IT'S POSSIBLE I WILL MAKE IT AND SEND YOU
Totally useless because every MNC considers quarter according to financial year I mean to say first quarter start from April