Date function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Below is an example of data. Without having to retype each date using the DATE function followed by the subtraction of the beginning and ending date, is there a way to calculate the difference without having to re-type the original dates in beginning and ending columns

First Date Last Date Differenc
2/15/2002 02/31/2002 ?
5/18/2004 7/13/2004
3/13/2002 4/19/2002
11/22/1976 4/15/2004
 
Since XL stores dates as integer offsets from the date system base date,
you can just subtract one date from the other (though 2/31/2002 will be
interpreted as 3/3/2002). Format the result as General or anothernumber
format.
 
Back
Top