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