Thread: Counting days
View Single Post
  #4   Report Post  
DaveShoe
 
Posts: n/a
Default


Greetings:

I am unclear on what you are searching for, however I will give it a
try:

If you are saying that you have 2 columns, each with a date and you
want to know the difference between the two, you can use a simple
subtraction formula.

if: a2=feb 3 and b2= jan 20
=a2-b2 gives you "14".

Be sure to format this last column as a number or general. You could
achieve similar results if you need to add days to dates, in which it
would yield a new date.
=a2 + 5 gives "feb 8"

Good Luck.

Dave


--
DaveShoe
------------------------------------------------------------------------
DaveShoe's Profile: http://www.msusenet.com/member.php?userid=315
View this thread: http://www.msusenet.com/t-1869397785