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 →

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 →