How to Manage a Group Project in Google Wave - Google Wave - Lifehacker: "The XMPP Lite Bot: One of the issues with adopting Google Wave into your workflow is the whole 'yet another inbox' problem. If you're working on a project in Wave but forget to check it every day, you can get notifications of wave updates via IM. The XMPP Lite bot can GChat you as project waves get updated. To use it, add the bot to your contacts (its Wave ID is wave-xmpp@appspot.com), and then add that same contact to your GTalk contacts list. Add the bot to any wave you want IM notifications from, and click the Subscribe button."
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