I have a spreadsheet in numbers with customers information including birthdays and I was wondering if there was formula that could highlight their birthday a week or two in advance so I have time to get a birthday card mailed out to them. I don't want to have to have to scroll through the list everyday checking because I could over look one. Any help would be appreciated.
Got a tip for us?
Let us know
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.
Numbers
- Thread starter GRMCKR
- Start date
- Sort by reaction score
I don't know for sure if there's a specific function, but you may be able to create an If function and use the current date/time as the evaluation criteria. Play around with that and see if you can figure something out.
Not helpful for the spreadsheet but why not just use Reminders for this. Super simple to setup and will even notify you on all of your iDevices too.
