If A1 = 1/1/2006 and B1 = 6/1/2006, then =DATEDIF(B1,A1) will return the
number of days between them.

Another way to do it would be:
A1= Today's date -- =TODAY()
B1= Event date
C1=DATEDIF(B1,A1)

The advantage of this is that TODAY() updates automatically as a new day
comes around.

Dave
--
Brevity is the soul of wit.


"Michael" wrote:

I have a begining date in one cell, an ending date in another cell and
would like to put the number of days left in another cell.

Can you help me out?

I thought there might be a way to update todays date each time I
opened the document and that cell would be formated to give the total
of days left but I am lost.

Thanks in advance

Peace

Michael