Numbers

[GRMCKR]

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.

 

[smallcoffee]

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.

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.

 

[Julien]

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.

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.

 

[maflynn]

You'll need an IF statement, probably put a value in a cell next to the D.O.B.

I'd recommend some sort of contact management software, which is designed for such tasks or at the very least using the calendar app for such things.