How many days do I have again?

It’s hard to calculate how many days are between a certain day and another, especially if they are far apart. If your deadline to file a motion is 60 days before your hearing date on October 12th, 2015, what date is that? Luckily, there are several ways to determine that calculation. We’re going to cover Excel, Outlook, and a web tool called Timeanddate.com.

If you frequently need to keep track of court calendar deadlines, services like Deadlines.com (formerly Deadlines on Demand) or Juralaw (if you practice in Illinois) can keep the dates straight for a price. There are several ways to count how many days for free, however, and best of all you can use these tricks for all your deadlines—not just court specific ones.

 

The first is with Excel. In cell A1 type the date of your hearing: 10/12/2015. In cell B1 type “=A1-60” and hit enter. Excel will calculate the date automatically, changing the cell contents to say “8/13/2015.” If the date of your hearing changes, replace the date in cell A1 and the date of your filing deadline will automatically change with it.

excel screenshot

 

To find out if that date falls on a weekend, click cell B1, go to the cell formatting drop down menu under the Home tab and select “Long Date.”

long date excel spreadsheet

 

The cell data will change to tell you what day of the week 8/13/2015 is. In this example it is Thursday, but if it were on a weekend you could adjust your deadline as needed.

If you don’t have Excel handy, you can also add or subtract a date on the web. Timeanddate.com has several different calendaring calculators. Use their date calculator to add or subtract from a date. Still using the example of 60 days until your hearing date on 10/12/2015, enter 10/12/2015 as your start date. Select “(-) Subtract” from the dropdown menu, and enter “60” under “Days.”

subtractdateweb

Press “Calculate new date.” The result will be “Thursday, August 13, 2015.” Timeanddate.com also features calculators to determine the number of days between two dates, time duration between exact times and finding the week number of any date.

Finally, there’s Outlook.

Enter the October 12, 2015 hearing for your client on your calendar. After the appointment is on your schedule, bring up the Go To Date box by right clicking the date (or typing Ctrl – G if you’re a keyboard shortcuts person).

hearing for my client

In the box that appears, place your cursor before the date and type “60 days before”

60 days before

Press OK, and you will be brought to August 13, 2015, where you can now enter a new event for your motion filing deadline. You can also find out dates in the future by typing “x days after.”

About Nora Regis

Nora Regis, Instructional Design Coordinator, Law Practice Management & Technology. Nora is a former paralegal, specializing in litigation and bankruptcy. Prior to working in legal, Nora was a technology helpdesk agent at UW Madison.