Thread
:
Date with Time
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
IT05
Posts: n/a
Date with Time
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!
Reply With Quote