Extract Records Between Two Dates in Excel (2 Methods) | Vivekananda Sinha | Video 203

[@ruploo58]

Absolutely amazing. But can we sort the filtered data.

[@Futureinhands]

Thanks. Sorting a filtered data is quite challenging

[@deepakkhurana9617]

Hello sir
नमस्ते
में तो आपका फैन हो गया हूं,कमाल का काम है ,आपका ,सबसे बड़ी खास बात आप प्रैक्टिस फाइल भी डाल देते हो ,यह सबसे बड़ी बात है👌

[@Futureinhands]

Thank you Deepak Ji 🙏

[@deepakkhurana9617]

@@Futureinhands Hello Sir
Please Sir. Meri query to Hal Kat dijiye

[@abdulsalam935]

Sir, very neat explanation. I have clearly understood which i haven't understand for the last two days from other videos. EXCELLENT. Thank you

[@Futureinhands]

Amazing. Keep learning ❤️

[@zakeermohamedkhan8750]

Excellent explanation

[@zakeermohamedkhan8750]

Bhai Excellent video and explanation.

[@l.b.pradhan3832]

Hello sir, I found your tutorial very useful and tried hands on practice with a dummy data. Unfortunately, it was not giving correct result which I suspected the cause to be due to my ms office 2021❤❤

[@Futureinhands]

Keep learning. Keep growing ♥️

[@virendrabisht8385]

Awesome trick sir 🙏🙏

[@zarinayasmin8421]

Nice....

[@muhammedriyasthekkekara8894]

Thanks, realy usefull.

[@vishnuvardhan6838]

Super Sir

[@Tarik-1336]

what about if have to count number of data in digit within two dates?

[@Futureinhands]

We can use ISNUMBER function in the formula

[@hsgusain2054]

Thanks Sir

[@kazisazzad9257]

Of the two methods, I prefer the filter function.

[@mohammadmahbubhasan4599]

Thanks a lot. How can I extract data between dates based on a customer? i mean extract data based on 3 criteria Customer name , start date, end date

[@Futureinhands]

You can use the third condition something like *($B$2:$B$26=$G$4) where $B$2:$B$26 is the customer range and $G$4 is the customer name to check.

[@mohammadmahbubhasan4599]

thanks for your reply. i tried but still problem.how can i send my data sheet to you?

[@abdulsalam935]

Sir how to extract data from another worksheet using this function

[@Futureinhands]

Same method. Just select the range from the desired worksheet. It will work fine.

[@abdulsalam935]

@@Futureinhands ok sir. I will try and inform you

[@abdulsalam935]

Sir, just now did as you told. It's working like a charm. Thank you Sir

[@abdulsalam935]

U have shown data extraction in the same sheet only

[@sunilkumar-jl7uf]

I like 1st traditional method

[@md.fahadhossain889]

Can you tell me with condition how can I use this?

[@Futureinhands]

Please specify any condition example.

[@redhaakhund1271]

👍👍👍👍👍

[@lakhindrakumaryadav1276]

Give up broo excellence

[@payamehussain2052]

IT is showing me date of 1/11/1900 while my starting date is 2-jan-22 and ending date is 31-jan-22

[@Futureinhands]

It means it not returning date. There might be problem with the formula. Please share the screenshot of the formula here along with the screenshot of the data.

[@miteshpatel7101]

Sir first example me data A1 se shuru hoga to hi sach ans aata he aesa kyu plz

[@Futureinhands]

Because hum row number capture kara rahe hai row function se. Isiliye index me hum first row se hi karna padega nahi to position shift ho jayega.

[@sameerkibatain]

Mere pass ek table hai column me date,persons name,category hai or mjhe specific date me specific category or name ko count krna hai. Jisky liye mne =countif=(daterange,">=",startdate, & "=

[@Futureinhands]

You can use countifs function

[@sameerkibatain]

@@Futureinhands wohi use krha hun mgr same date ek br count honi chahye bar bar nh iska koi solution

[@ansariabid5623]

​@@sameerkibatain ek reference column add karle, aur jo date double hai uske reference column me duplicate daalde, fhir countifs conditions use karle ho jaayega

[@tempwork9401]

it's not working on my exel. Could you please give me your email address.?

[@Futureinhands]

Have u downloaded the workbook from the link in the description?