Once again I need your expertise on a matter. I have a sheet and on this sheet, there are students' birthdates. What I would like to do is, I will put a number on top of a column, and if any birthdate is between the range of today() and today+the number, I want them to show up under this column. Something like this:I want to also say, in the picture as you see if a name shows up under Tomorrow section, it is not showing up in another category, from what I understand is to get this data, we basically need to compare those birthdates to today(), and for example for tomorrow x = today()+1 AND x != today() // if this request is going to cause too much workload, you can dismiss it, showing the same name under every category is fine, as long as I get the closest ones, so that I can keep track of them all the time. Thank you for all the help you do, I really can't appreciate enough for such a huge help, God Bless You All.Here is the excel file of the picture above https://docs.google.com/spreadsheets/d/1rq0Q5Ij6dBei1q-vkPICBcEZ-8k56ccAk5kQYlHssM0/edit#gid=0(file is open to public - no need a google account to see)
How to get data from a column by sorting Birthdates' column according to given a date? (Google Spreadsheet)
google spreadsheets
Does this work?C2: =FILTER(A2:A7, B2:B7 = TODAY())D2: =FILTER(A2:A7, B2:B7 = TODAY() + 1)E2: =FILTER(A2:A7, B2:B7 >= TODAY() + 2, B2:B7 <= TODAY() + 7)F2: =FILTER(A2:A7, B2:B7 >= TODAY() + 8, B2:B7 <= TODAY() + 14)G2: =FILTER(A2:A7, B2:B7 >= TODAY() + 15, B2:B7 <= TODAY() + 30) 