quantinfying dates?
 

Just wondering how I can quantify dates? I have two ranges of dates,
and need to calculate the difference between the dates. (ie: Jan1,05 to
Jan1,06 = 365 days)

Thanks,
C.

quantinfying dates?
 

Cjwenngatz,
Just put values in two cells and minus them from each other.
A1= Jan 1, 2005
B1= Jan 1, 2006
C1=B1-A1

Then format the cell as a number, and you will get the difference.

HTH
Cal


" wrote:

Just wondering how I can quantify dates? I have two ranges of dates,
and need to calculate the difference between the dates. (ie: Jan1,05 to
Jan1,06 = 365 days)

Thanks,
C.

quantinfying dates?
 

Subtract the two dates.
=A1-B1
or do the dates have to be in the formula?


wrote:
Just wondering how I can quantify dates? I have two ranges of dates,
and need to calculate the difference between the dates. (ie: Jan1,05 to
Jan1,06 = 365 days)

Thanks,
C.

quantinfying dates?
 

Should you want to get a bit fancier in the difference between your two dates
give this a look see (undocumented in XL and kinda nifty).

http://www.cpearson.com/excel/datedif.htm
--
HTH...

Jim Thomlinson


" wrote:

Just wondering how I can quantify dates? I have two ranges of dates,
and need to calculate the difference between the dates. (ie: Jan1,05 to
Jan1,06 = 365 days)

Thanks,
C.