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

Rumor Mill: New mac Mini Coming?

There are reports all over the Internet about a new Mac Mini to be possibly released at MacWorld.  TUAW is reporting that a new version of the Mini will include an optical drive that can be swapped for a second hard drive.  The housing will look much like the Time Capsule with a "lip" for consealing the optical dive slot and cooling. Whether true or not, I would like to see a few features in a new Mac Mini. More RAM (Of course.) NVIDIA chipset. FW port for external HD My main use for a Mini would be for media.  A Mini on my network using Front Row would be great for movies and TV.  (Sorry, Apple TV.)
3 comments
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