I have a large and constantly evolving list of contact's birthdays. They all include the year, but that is irrelevant to our needs. I would like to have a cell that calculates whether a birthday (day and month) is between Today and 14 days from today.
I have been using this formula:
But of course, it is comparing everything including the year - so of course everyone that was born before today. I know my formula isn't complete, but I'm just using that for the purposes of clarity.