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