Midyear Roundup: My Best Dates

Some of my fave Excel Date Functions. Some old, some new; all designed to help track the passage of time.

Date Functions:

EOMONTH
returns the last day of the month
EOMONTH ( start_date , month )
EDATE
returns the date x number of months before/after a given date
 EDATE ( start_date , months )
NETWORKDAYS
calculates the number of working days
(see also NETWORKDAYS.INTL)
 NETWORKDAYS ( start_date , end_date , [holidays] )
TODAY
returns the current date
 TODAY( )
WEEKNUM
returns serial number for a given week
 WEEKNUM ( date , [week_start] )
WORKDAY
calculates the next valid work day
(see also WORKDAY.INTL)
WORKDAY( start_date, days, [holidays] )

 

YEARFRAC
returns the date as a fraction of the year
 YEARFRAC ( start_date , end_date , [basis])

Cheers!

hɔuᴉnb

Additional reading:

Comments and questions are always welcome!

Advertisements

Hidden Excel: Find Date Differences with DATEDIF

In honor of the 40th anniversary of J.K. Rowling’s seminal classic, Harry Potter, this post magically exposes a hidden excel function!

Date Difference between J.K. Rowling’s Birthday and Harry Potter Movie Debut

Ever wonder if your spreadsheet is keeping something from you?

DATEDIF is an under-documented function. It allows  you to calculate the difference between two dates. Although it doesn’t appear in the Function Wizard (it exists to insure backward compatibility with Lotus and earlier Excel versions) it is a powerhouse when it comes to calculating date differences.

Using DATEDIF function:

  • Format: =DATEDIF ( date1, date2, “interval”)
  • date1 must be the earlier of the two dates or an #NUM error is returned.

Interval Arguments:

y Years
m Months
d Days
ym Months, years excluded
yd Days, years excluded
md Days, years and months excluded

Cheers!

hɔuᴉnb

Additional reading:

Comments and questions are always welcome!

Acrobat Page Numbering

Often times, a PDF’s pagination doesn’t match the pagination as displayed in document. For example, a document containing caption, contents and authorities pages, may have its first narrative page set 7 pages into the file. This makes navigation problematic.

Many courts now require that the PDF page numbering match the original document pagination. Follow these instructions to renumber your PDF.

To Renumber Pages in an Acrobat PDF

To label or suspend numbering for an un-numbered page
(e.g. Caption pages)

  1. Display Page Thumbnails by clicking Thumbnails icon at left.
  2. RT+CLICK on the page thumbnail and select Number pages. The Page Numbering dialog appears.
  3. In the Pages section choose ‘Selected’.
  4. In the Numbering section select ‘Begin new section’.
  5. Click Style drop-down and select None.
  6. Set Prefix to appropriate label (e.g., Caption, CoverPg, etc.) or leave blank.
  7. Click OK.

To renumber pages within a section (e.g., Table of Contents)

  1. Display Page Thumbnails by clicking Thumbnails icon at left.
  2. To select multiple pages, click on the first page of the section, then scroll down and SHIFT+CLICK on the last page.
  3. RT+CLICK on one of the selected thumbnail pages and select Number pages. The Page Numbering dialog appears.
  4. In the Pages section choose ‘Selected’.
  5. In the Numbering section select ‘Begin new section’.
  6. Click Style drop-down and select desired format (e.g., i ii iii).
  7. Set Prefix to blank (i,e. leave this field empty).
  8. Set Start to ‘1’.
  9. Click OK.

Cheers!

hɔuᴉnb

Related posts:

Comments and questions are always welcome!

Dude, Where’s My Car? Parking with Google Maps

Although I’ve not had the cinematic misfortune to see Ashton Kutcher utter this titular question, I have, occasionally, misplaced my car.

But no more; with the latest update to Google Maps  you can record where you parked your car, and when.

Click image for video.

To Record Your Parking Spot

  1. Open Google Maps.
  2. Press the Blue dot . A menu will appear.
  3. Select Save your parking.

Notifications remind you when it’s time to feed the meter, and a map directs you back to your vehicle.

Cheers!

hɔuᴉnb

Related posts:

Comments and questions are always welcome!

Use Google to Find Your Phone

Honey, have you seen my phone?

You don’t need a tracking device to locate your Android phone. Just log into your Google Play Store account and access the Android Manager.

You can have your phone send out a Here I am! ring, or lock the device with an “If found, please return..” message;

…to reunite you with your lost loved one.

To Locate your Android Phone

  1. Go to https://play.google.com.
    Note: you will need to be logged into your Google account.
  2. Click the settings googlesettingsgearicon and select Android Device Manager.
    Your phone’s location location-icon-png-14will appear highlighted.
  3. Select preferred option(s):
    a. Click Ring to have your phone ring.
    b. Enable and Select Lock to secure your phone.
    c. Click Erase to wipe your personal data.

Cheers!

hɔuᴉnb

Related posts:

Comments and questions are always welcome!

Heading and Bookmark Shortcuts

In addition to making it easy to generate PDF bookmarks from a Word document (click link to see  how)Headings and Bookmarks afford your reviewers an easy method of navigation.

headings-and-bookmarks

Here are shortcuts to Applying Heading Styles and Creating Bookmarks.

To quickly apply Heading styles

  1. Select the item by placing insertion point anywhere on that line of text (Heading styles will auto-apply to the entire paragraph).
  2. Hold CTRL and SHIFT down and press 1, 2, or 3 to apply that corresponding outline level (e.g., CTRL+SHIFT+2 applies Heading 2 style).

Note, only the first 3 Heading styles have shortcut keystrokes pre-assigned to them. Alternatively, you can also Press CTRL + SHIFT + S (Apply Style shortcut) then select or enter the style name.

To create Bookmarks

  1. Select the text to bookmark.
    Note: Unlike Heading Styles, you must select all text to be included in the bookmark.
  2. Press CTRL + SHIFT + F5. The Bookmark dialog appears.
  3. Enter your bookmark name:
    -name can contain only letters and/or numbers
    -name cannot begin with a number
  4. Click Add.

Note: If you use the same name as an existing bookmark the original will be overwriten without warning.

Cheers!

hɔuᴉnb

Related posts:

Comments and questions are always welcome!

Auto-generate Bookmarks in an Acrobat PDF

autobookmarking-in-acrobat

 

An earlier post showed an easy keyboard shortcut for creating bookmarks. Here’s an even easier method of creating a PDF from a Word document, where the bookmarks, practically, create themselves. And the beauty of it is that it preserves the outline hierarchy (i.e. creates indented bookmarks) as defined in your document.

Note: The document must either be in outline format (with Heading styles), or formatted with Word-generated bookmarks.

Click here to watch ~1 minute demo

Converting your Word Document into a PDF with Bookmarks

  1. In Word: click File, Save As, then Browse to select a folder to save to.
  2. On the Save As dialog, in the File name area, enter the file name.
  3. Click the Save as type drop-down and select PDF (*.pdf).
  4. Click Options…
    autobkmrk1-options
  5. Check Create bookmarks using: and select Headings.
  6. Click OK.
  7. Click Save.

Cheers!

hɔuᴉnb

Related posts:

Comments and questions are always welcome!