I have a sheet on which there are students' birth dates. What I would like to do is to put a number on top of a column, and if any birth date is between the range of today() and today+the number, for them to show up under this column. Something like this:
If a name shows up under tomorrow
, it is not showing up in another category. As I understand to get this data we need to compare those birth dates 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 I can keep track of them all the time.
Here is the file of the picture above.