produce a list from cells based on dates in adjacent cells

[kevdob]

Hi all, Ive used this forum for a while and it has always answered my queries by reading, this is my first post as I cant seem to find the answer. Any help would be greatly appreciated.

I have a database of people with dates along side. I would like a live list that populates a cell based on the date, for example:

List of people with their dates of births in adjacent cell. I would like another cell that would populate a list of people who's birthday is this week (or less then 7 days days from today())

I hope this makes some sense!

Thanks in advance

 

[Joe4]

Welcome to the Board!

One way to do this would be to add a "helper" column with a formula that checks to see if their birthday is with 7 days.
Then, use Filters to only show the "True" values.
Here is a formula (which checks to see if the date is within 7 days, before or after today):

=IF(ABS(TODAY()-DATE(YEAR(TODAY()),MONTH(B1),DAY(B1)))<=7,TRUE,FALSE)

 

[kevdob]

Thanks Joe4. Ive tweaked it a little to make it fit but that's pretty good.
Just for curiosity, what is the ABS for at the start?

Thanks again.

 

[Joe4]

You are welcome.

Just for curiosity, what is the ABS for at the start?

That is the Absolute Value function. See: https://www.techonthenet.com/excel/formulas/abs.php

That way if the date subtraction returns a negative number of days, it would make it a positive number (I don't care if it is less than 7 days before or after, just that it is within 7 days).