Tom Ogilvy wrote:
> just subtract the earlier date from the later date. The integer part of the
> answer is the days between. The decimal part is the portion of a 24 hour
> day. Dates/Time are stored as the number of days from a base date (1900).
> So if you subtract them from each other, you get the difference in days.
>
Thanks, it wasn't working because I was referencing the wrong cell which
was a string not a date.

JOhn