Thread: Dates formula
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stephane Quenson Stephane Quenson is offline
external usenet poster
 
Posts: 53
Default Dates formula

You can also simply type =A2-A1, as a date is a number with the integer part
representing a number of days from a reference date, and the fractional part
being the time or a fraction of a day (e.g. 0.25 is 06:00 am).