Thread: Dates formula
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default Dates formula

So, to be on the safe side, if you want the difference in whole days
between two dates, make sure the date you subtract is equal to or less
than the other date


Or, you can use the ABS (absolute value) function on the difference.

Rick