Skip to main content

Popular posts from this blog

Calculate Age or Years Elapsed in an Apple Numbers Sheet

Often it is useful to show a person's age or years elapsed since a start date.  For example: Hire Date: 4/1/2012 - Years of service: 1.5 Here's a formula for Numbers that will do the trick: =IF(ISBLANK(cellReference),"",DATEDIF( cellReference ,TODAY(),"D")/365.2425) Replace the cellReference with the actual cell reference. i.e.: (A1)  So here's the breakdown: =IF(ISBLANK(cellReference),""  --- this checks to see if there is a start date in your referenced cell.  For example say your spreadsheet has a cell (A1) that holds a date of birth, but it is not yet referenced, this will result in an empty string. (Blank cell) Otherwise, it calculates the years:  DATEDIF( cellReference ,TODAY(),"D")/365.2425) DATEDIF compares two dates. The first date is your cell reference i.e.: (A1) The second is the current date according to your computer, iOS device: TODAY()  returning the Day -  "D" Then the difference is divi...
Post a Comment
Read more

Printing Address Labels with Mac OS X Leopard

Oh, boy.  Was my wife frustrated.  She wanted to simply print a sheet of address labels with her Mac.  No templates anywhere it seemed. So I went on a quest. Here is what she wanted to do: Simply print an entire sheet of labels using the same address. Should be a piece of cake, right? WRONG!  Address book does have many templates for printing labels, true, but only one at a time. A good label printing template should do the following: (IMHO) Print any number of different address labels any number of copies. Have the ability to "skip" over used labels so the labels left from previous jobs are not wasted. Be relatively easy to use. In my search for an answer, I came across this blog entry on Tech-Recipes.com that seemed to be the answer. But on further investigation it was a dead end. Why, then, does Address Book leave this feature out.  Ask Mr. Jobs I guess.  There is nothing at all on the Apple forums about the subject that I could find.  Although many were asking! So, what ...
4 comments
Read more