Can I count down days till an event?
 

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

Can I count down days till an event?
 

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

Can I count down days till an event?
 

try
=date(year,Month,Day)-today()

"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

Can I count down days till an event?
 

Where cell A1 contains your end date:

The "count down" cell contains:

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



"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

Can I count down days till an event?
 

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

Peace

Michael
"Michael" wrote in message .. .
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

Can I count down days till an event? Still not working...
 

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
"Michael" wrote in message ...
Thank you everyone. I will try these and see the results.

Peace

Michael
"Michael" wrote in message .. .
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

Can I count down days till an event? Still not working...
 

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



"Michael" wrote:

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
"Michael" wrote in message ...
Thank you everyone. I will try these and see the results.

Peace

Michael
"Michael" wrote in message .. .
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

Can I count down days till an event? Still not working...
 

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" wrote in message
...
Make sure, when using my solution, that the countdown cell is
formatted as
General. There are three arguments for the Datedif function.

<Snipped