Pages for iPad | In-Depth Review | The Mac Observer: Apple’s iPad is a great device for watching movies and TV shows, listening to music and playing games; and thanks to apps like Pages, it works great as a content creation device, too. Pages for the iPad is a slimmed down version of Apple’s word processor and page layout application, and it works surprisingly well for on-the-go document creation and editing.This is a very good article describing the features of Pages for iPad. I use it more than I thought I would. My wife uses it exclusively now that she has moved to the iPad as her only computing device.
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...
Comments