I'm trying to create a countdown to an event.
In A2 I have the date and time as 12/1/2012 2:00:00 PM
In A1 I have: =A2-NOW() and it is formatted as: d "Days" h "Hours" mm "Minutes" ss "Seconds"

The trouble is it doesn't return the correct number of days.

Right now it returns: "20 Days 14 Hours 05 Minutes 07 Seconds" which is off by 31 days.
It seems like no matter what date I put in, it wont return more than 30 or so days.

What's the trick?