group query by anand-2

Key Takeaways

this is rajant Excel Guru once again this query actually I first of all I like to tell you something that this query from Anand I call him Junior Bill Gates he has sent ify queries totally I try to share a solution daily one because I'm not having a sufficient time to record edit and I have to upload in YouTube so it takes much time for that for that reason daily I try to share a solution here is the solution which I'm going to share you okay here what they ask means you have to find the sales before 7 days below given date so he has given this date okay so we have to find the seven last seven days sales as for this date it's very very very easy okay I'll show you how to do it first of all what I'll do equal to is this okay I'll use some if okay some ifs mean it it is having more than one condition we can enter more than one condition and first to thing is some range this is some range okay comma what is the criteria range this is the criteria R comma you want last seven days from this date you want last 7 days so what you have to do greater than greater than or equal to this date - 7 right okay I have to keep Comm over here what to keep Comm okay this is the criteria okay and now the criteria two is same date range but you have to use less than or equal to this it that's it this is the logic behind this query okay you can do it with some product also thisy from very big company okay so out of 50 I don't know why no one is answered this TW maybe having they got any confusion over there but it's very easy you have to use submit for it and press enter that's it if I any if I enter any date 13th September 1917 not 20117 it is 1 1917 okay 13 + 7 20 20 September okay September me 9 okay answer see here it is okay understood there is no behind 7even days okay there is no behind 7 days for that reason it has pick uping only that thing if I take any March much October okay October 1912 21st October 1912 so I addite 26 26 27 October 1912 okay okay it's very easy okay 21 October I use so it add this one also this one this one this one yes we can take it over here okay understood thank you guys I'll share more more videos whenever I get your time thank you guys thanks for your support please like share and subscribe my channel you