Want to subtract two dates with one of the dates showing time. Time needs to
be ignored.

Spreadsheet Example:
6/20/2005 12:26:00 PM
06/21/2005
=SUM(G2-H2) shows a value of "0"

Goal is to show "1"

Thanks!

int(h2) would drop the time portion from a date/time entry. So =g2-int(h2)
should give you the days from h2 to g2 (assuming that there's no time on g2;
if there is, then =int(g2)-int(h2) ). --Bruce

"IT05" wrote:

Want to subtract two dates with one of the dates showing time. Time needs to
be ignored.

Spreadsheet Example:
6/20/2005 12:26:00 PM
06/21/2005
=SUM(G2-H2) shows a value of "0"

Goal is to show "1"

Thanks!