Tag Archives for " dates "

4 Want that “15th day of August, 2012” to self-update? Here’s how

If your documents are anything like the ones I’ve worked on over the years, there’s at least one section (the “Respectfully submitted” or the Certificate of Service in pleadings or the notary acknowledgement, for example) that has this in it:


Dated this the 15th day of August, 2012


If you start drafting the document on the 15th but don’t actually file (or sign or whatever) until, say, the 21st or the 30th or, heaven forbid, sometime next month or year, you’re either going to have to leave blanks for the day, month and/or year while you’re drafting or remember to update all those dates when you finalize the document.

But what if you didn’t have to do either one? What if your document was smart enough to do its own updating, based on the date you saved it last?

Keep reading →

Guest Post @ Lawyerist: 3 Outlook Quick Tricks

Over on Lawyerist, I’ve been writing a lot lately about Microsoft Outlook — how to use tasks and categories and how assign tasks to other people, for example. This week, I’ve gathered up three features many Outlook users don’t even know about.

For instance, did you know that Outlook can automatically calculate “30 days from now” or “one week from today” when setting a due date? Or that you can redirect e-mail replies to another user? Or that Outlook can keep all of the e-mails in a particular conversation together for easy reference?

If these tricks are news to you, click here for the full illustrated tutorial.

4 Reader Question: Calculate difference between two dates in Microsoft Excel

A reader contacted me recently with a deceptively simple Microsoft Excel question: “How do I calculate the difference between two dates?”

I say “deceptively simple” because the answer depends upon the context, namely, whether the two dates being compared are actually embedded in cells within the Microsoft Excel spreadsheet.

Keep reading →