View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
CBrine[_4_] CBrine[_4_] is offline
external usenet poster
 
Posts: 11
Default 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.