Whats the formula for a self updating countdown timer between 2 times on
different days i.e. now and my birthday (for instance) in 6 month's

Enter your birthday in A1 and in another cell, enter:

=A1-TODAY()

The trick is to format this cell as Number rather than Date. The value will
update every day you open the worksheet.
--
Gary's Student


"Bikertyke" wrote:

Whats the formula for a self updating countdown timer between 2 times on
different days i.e. now and my birthday (for instance) in 6 month's

=date(yyyy,mm,dd)-now()

where dd = day, mm =month and yyyy = year
--
Hope this helps
Martin Fishlock
Please do not forget to rate this reply.


"Bikertyke" wrote:

Whats the formula for a self updating countdown timer between 2 times on
different days i.e. now and my birthday (for instance) in 6 month's

Was hoping for a countdown timer in days, hours, minutes and seconds between
now and say midnight on 25 May 2007 (for instance) that will undate on a
second by second basis i.e. permanently countdown and not just refreash when
actioned.

I don't think it is possible to do what you want in real time unless you have
a macro running in the backgroud checking for a change in time and updating
the cell.

But you would not be able to do anything else.


--
Hope this helps
Martin Fishlock
Please do not forget to rate this reply.


"Bikertyke" wrote:

Was hoping for a countdown timer in days, hours, minutes and seconds between
now and say midnight on 25 May 2007 (for instance) that will undate on a
second by second basis i.e. permanently countdown and not just refreash when
actioned.

I've just seen a new method that I did not know erxisted.

OnTime.

It works quite well but you have to play around with it and I'm not sure for
long periods but havea try with it. See the help pages for information.


--
Hope this helps
Martin Fishlock
Please do not forget to rate this reply.


"Martin Fishlock" wrote:

I don't think it is possible to do what you want in real time unless you have
a macro running in the backgroud checking for a change in time and updating
the cell.

But you would not be able to do anything else.


--
Hope this helps
Martin Fishlock
Please do not forget to rate this reply.


"Bikertyke" wrote:

Was hoping for a countdown timer in days, hours, minutes and seconds between
now and say midnight on 25 May 2007 (for instance) that will undate on a
second by second basis i.e. permanently countdown and not just refreash when
actioned.