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

ScreenFlow

WOW! That's all I can say for ScreenFlow. Although the product is $99.00 every penny spent is worth it. Everyone who uses a Mac and likes to help other Mac users should investigate the possibility of using this program. One can download a trial version in order to try it out. What does it do? Well, for starters, simply recording EVERYTHING on your screen to show your Mom how to add a new email address to Address Book, or even simply record yourself with your Eyesight camera telling how to use iCal to organize your life. Here are some features I found useful: Screen recording. Video recording. Audio recording. One can record any of the above simultaneously or individually and then combine the result.  The possibilities are endless.  For example, I have many Deaf friends and have found that most video tutorials contain audio commentary.  What I have been able to do with ScreenFlow is record the screen actions and then overlay myself signing the instructions using ASL (American ...
6 comments
Read more