Numbers

Discussion in 'Mac Basics and Help' started by GRMCKR, Dec 21, 2014.

  1. GRMCKR macrumors newbie

    Joined:
    Nov 29, 2011
    #1
    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.
     
  2. smallcoffee macrumors 6502a

    Joined:
    Oct 15, 2014
    Location:
    North America
    #2
    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.
     
  3. Julien macrumors G3

    Julien

    Joined:
    Jun 30, 2007
    Location:
    Atlanta
    #3
    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.
     
  4. maflynn Moderator

    maflynn

    Staff Member

    Joined:
    May 3, 2009
    Location:
    Boston
    #4
    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.
     

Share This Page