Just watched this. Thank you for explaining things in such an easy and clear way. 🥰

FILTER is a wonderful function. Great tutorial. The period calculations are fantastic. I’m a current bill due date spreadsheet. Some of them are monthly, weekly, annually, etc. I’ll use yours a starting point. Thanks

@TeachExcel

3 жыл бұрын

Thanks Patrick, I'm really glad you liked the tutorial :)) FILTER is just so great, couldn't agree more! And definitely take my file and roll with it! I think that the setup should be flexible anough to change it around without much difficulty and the date formulas should also work well for many different combinations. I think when I get more time later this year I will make a small course on dates for Excel and how to get certain date periods, but, until then, feel free to ask for any help in getting your workbook up and running on the forum on TeachExcel.com

This was beautiful, thank you so much!!

Thank you very much! This is exactly what I was searching for.

Very original and creative case. Excellent tutorial. Thank you so much for sharing it.

@TeachExcel

3 жыл бұрын

Thank you Ivan, I'm happy that you think so, and I'm really glad that you liked it! :)

Excellent tutorial! Thank you :-)

Absolutely awesome tutorial!!!! Thank you.

@TeachExcel

3 жыл бұрын

Thank you so much for your comment!!! I'm very glad you like it :))

Excellent! Thank you!

Thank you it really helped

Very helpful tutorial. Thank you so much!!

@TeachExcel

3 жыл бұрын

I'm glad you think so! You are very welcome Hang!

Man thank you very much!!!

good video add very clear information passion for creating the best content

Thank you for this usuful video! I really need this to making report abour our budget! Thank you sooooo much

@TeachExcel

2 жыл бұрын

You are most welcome!!! If you need additional automation, you can always try out VBA/Macros - here is my course that takes you from Beginner to Expert in VBA: www.teachexcel.com/vba-course-update.php?src=yt_comment_reply_hj6JSSQIrdw

That's amazing sir

Hi.. interesting approach. I've done something similar, but storing the live data in a proper Excel Table format (either copy and paste in or via Power Query) and then adding slicers for all the columns that I want to filter. For things like this/last month/year, it may require helper columns to get the functionality desired. Just another approach. Thanks for your tips.. always learn something :)) Thumbs up!!

@TeachExcel

3 жыл бұрын

I'm glad you like it Wayne :) And thanks for this great comment! I LOVE helper columns combined with the strategy that you mention and it is one of my favorite ways to make this kind of setup as well.

Great video, thank you. I wish you also could include the This and Last Quarter as well. Anyone could you please let me know what formula/s we should use if we also need to include Quarters as well? I would appreciate it.

It is great. Help me a lot

Great video. May I check how to extract my data if my data consists of a start date and end date?

Great video, thank you. How about creating a dynamic report showing the totals in this format: This Month, Last Month and this quarter, last quarter and this year, last year at all times without any extra steps. something like a dashboard which always only automatically calculates and shows above mentioned values?

Excellent !!!!

Very Educative

Great Tutorial On The Simply Awesome FILTER Function...Thank You Sir :) P.S Still Get A Headache Looking At The Scary Old School Formula!!

@TeachExcel

3 жыл бұрын

Thanks Darryl! And, man-o-man, I honestly didn't want to include it until I remembered that I did a whole tutorial on it in the past (I must have been crazy to do that hahaha).

Thank you

Very informative and useful video, thank you. I am trying to do something similar with dates in the future (next 10 days, next 5 days) how would I apply that to the formulas?

Tutorial very useful tutorial

Thank you so much

@TeachExcel

3 жыл бұрын

You are very welcome!

Nice video man, this is truly useful. Gonna save it in my excel folder =)

@mohamedezequiel9458

3 жыл бұрын

pro tip : watch movies at Flixzone. Been using it for watching all kinds of movies these days.

@mustafazion1737

3 жыл бұрын

@Mohamed Ezequiel Yea, been using flixzone} for years myself :)

Very nice sir 👍👍👍👍

I watched your video on Date Filter Magic, and I think it is great. I would like to utilize it in my Budget & Check Register file. I am using Excel Version 16.54 for Mac. I would like to be able to track data on an ongoing basis, since I am constantly adding debits and credits to my check register, savings accounts, etc. Must I do anything special to make this work.

Awesome 🙏

@TeachExcel

3 жыл бұрын

Glad you like it :))

I giggled when you titled your sheets R2 D2 :)

@makubexho

Жыл бұрын

What’s so funny about it?

very informative. i ave older version of excel. and i dont have =filter. can you pls teach us how to do it? .

hello, thank you for this tutorial. I would like to do something similar but the drop down would be "total year" then the name of the months. I can't wrap in my head what formula should I do. By the way, happy birthday to this video :D

Can you doo this if you want too see the overall "general data", and still be able to filter out what particular year you would like too see.

Thanks for this Tutorial. But please, my table array is not updating to the Table name as i selected the array when applying the filter function. What could be wrong?

Hi, I have a data where it has 7k customers' info for the complete year for paid and unpaid list. is there any formula or shortcut to know when was the last time the customer paid in which month and year?

Hi new sub here. Just have one question, is there a way to lovk a column after each day has passed? Thanks in advance!

I thought I was the only one hiding stuff to make it look better. Btw, what happens if you print the entire sheet? Does the hidden columns and data in white font get printed?

Do you have any idea on how to get This week and Last week data?

how can i dynamically analyse off of this information?

Hi, thank you for your teaching skills. Mine all works perfecty, but if i add Last 7 Days to dropdown and open and close, i get no sales. I checked the TableRaw and made sure their are dates in the last seven days, as i said all the other functions work EG.... this month, last month, this year, last year. I used =TODAY() - 7 , I get no report also tried =TODAY() - 14 and no results, missing something. Thank you guys

Any chance you could let me know how to add Quarters as well? This Quarter, last Quarter please?

I NEED HELP! PLZZ im trying to do something similar but more specific i guess. im a server and ive been working on an excel file to track my tips and sales percentages tip outs etc, it's very complex and im completely new to excel so it took me like two months. i'm trying to recreate an app that i was using but doesn't track enough details. in this app there are tabs on top for sorting the data yearly, monthly, weekly and biweekly and "all" and then at the bottom you can toggle between all of the data with arrows, between the 2 arrows there are 2 dates based off of the filter (the corresponding dates of the month, the week etc) but youre not limited to just "this month" and "last month", but you can continue to toggle between all months by clicking the arrow. i've tried with slicers and it kind of works but not as efficient or specific as i'd like it to be PLEASE TELL ME if you think that is at all possible on excel

Why not using advanced filter with old version ?

How would you zero in on a year you want to find specifically, such as having various years in an Excel Sheet with a lot of 2002, 2005, 2017, and 2021. You want to find the date 2021 specifically and highlight it all in a different color.

Good jub hehehe, i like when zooming, please create simple pos program,

Can you demonstrate or explain formulas using fiscal months and years, instead of calendar years?

@TeachExcel

3 жыл бұрын

I probably won't have to ability to fit such a tutorial in for a while but you could ask for some help for this on the forum on TeachExcel.com - I would also play around with the functions that I show you in this tutorial though because they can be used to make a wide range of date periods without tooo much difficulty.

Hi, thank you for the interesting video. When I enter the formula with the "FILTER", the D2 gives me a #NAME? sort of error. It is definitely because I am using Excel 2016. The other thing is, when I use the IFERROR formula on the last part of your video, the formula does not populate the cells even if re-copy and re-paste all the formulas on the extent of the worksheet. But thank you.

hello, I did it but only the first row is showing, i can see the formulas below but it is not showing the data. what am i doing wrong?

how about specific date?

How to do this in Google Sheets?

The =filter option is not showing up anyone has idea how to get

having an issue, my cell displays N/A even though I did it exactly as you have so easily explained...hmmm?? =VLOOKUP(E3,TablePeriods,2,FALSE). Can you provide some sort of explanation so I can fix this? This will make my life so much easier...

I made IF Error INDEX formula, but no data is showing at the place of formula.

I have copied formula in all cells. But from second row result blank. What wrong here? I have followed your excel file also. My Excel verison 2010

This was a good tutorial but you lost me around the 17:55 mark because I'm using Google Sheets to budget (Excel's great but I need Sheets so that I can edit where ever I am, not just my personal computer). It's not as easy as Excel to create or name a table, I don't know where I went wrong because it keeps giving me error messages. Do you have explanation videos using Google Sheets? Thanks!

sad that my excel version still dont have the filter formula :'(

@TeachExcel

3 жыл бұрын

I wish they would give an update for older versions and just allow it to be used in all of them back to 2007 - would be amazing! If you would like any help implementing the older formula in my tutorial, you can feel free to ask in the forum on TeachExcel.com and you can upload a sample file there as well.

👍👍👍👍👍

Where is YTD? 😢

Poor…