Can I count down days till an event?

M

Michael

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
 
D

Dave F

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
 
R

Ricter

Where cell A1 contains your end date:

The "count down" cell contains:

=Datedif(Today(), A1, "D")
 
M

Michael

Thank you everyone. I will try these and see the results.

Peace

Michael
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
 
M

Michael

None of the above worked, bummer. =today() gave me the correct date, I then typed in the events date 11/07/2007 and in the next cell I tried =datedif(h9,g9) of course g9 being todays date and h9 being the event but I end up with an error message saing

"You've entered too few arguments for this function.
To get help with entering arguments for the function, click ok to close this message. Then on the formula bar, click on the equal sign button (located to the left of the equal sign in your formula).

I have no equal sign to the left of the equal sign in my formula. Have I not installed something? I guess the word I'm looking for is add ons or what ever.

Thank You

Peace

Michael
Thank you everyone. I will try these and see the results.

Peace

Michael
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
 
R

Ricter

Make sure, when using my solution, that the countdown cell is formatted as
General. There are three arguments for the Datedif function.
 
M

Michael

Thank You Very much....

As soon as I changed the format of the cell and hit enter it worked.

Thank you again

Peace

Michael


Ricter said:
Make sure, when using my solution, that the countdown cell is
formatted as
General. There are three arguments for the Datedif function.
Click to expand...
<Snipped>
 
Top