Hi guys/Gals

Im desperatly trying to work out how to put a countdown on a excel sheet for
things that are due to expire.
I have a hundred and one uses for this, but for love or money I cant get it
right.

I need the Expire date showing, along with the number of days till
experation, and of course, this would up date daily, cause microsoft is nice
like that.

Any none complicated ideas???

Thanking you all in advance

Sweetie

Exp. date being in A2
=A2-TODAY()
Format the result cell as General!

Regards,
Stefi

€žSweetie€� ezt Ã*rta:

Hi guys/Gals

Im desperatly trying to work out how to put a countdown on a excel sheet for
things that are due to expire.
I have a hundred and one uses for this, but for love or money I cant get it
right.

I need the Expire date showing, along with the number of days till
experation, and of course, this would up date daily, cause microsoft is nice
like that.

Any none complicated ideas???

Thanking you all in advance

Sweetie

the date is =now()

the number of days until expiration is

A1 = 10/1/08
Expiration is
= int(A1-Now())

if yo want to combine them in a cell
="Expiration : "&TEXT(A1,"mm/dd/yy")&"; Days Until Expiration :
"&INT(A1-NOW())
"Sweetie" wrote:

Hi guys/Gals

Im desperatly trying to work out how to put a countdown on a excel sheet for
things that are due to expire.
I have a hundred and one uses for this, but for love or money I cant get it
right.

I need the Expire date showing, along with the number of days till
experation, and of course, this would up date daily, cause microsoft is nice
like that.

Any none complicated ideas???

Thanking you all in advance

Sweetie

Or use =A1-TODAY()
Note that you get a day's difference because of the truncation of the
non-integer part after subtracting NOW(), so decide whether you want the
count of days to be inclusive or not.
--
David Biddulph

"Joel" wrote in message
...
the date is =now()

the number of days until expiration is

A1 = 10/1/08
Expiration is
= int(A1-Now())

if yo want to combine them in a cell
="Expiration : "&TEXT(A1,"mm/dd/yy")&"; Days Until Expiration :
"&INT(A1-NOW())
"Sweetie" wrote:

Hi guys/Gals

Im desperatly trying to work out how to put a countdown on a excel sheet
for
things that are due to expire.
I have a hundred and one uses for this, but for love or money I cant get
it
right.

I need the Expire date showing, along with the number of days till
experation, and of course, this would up date daily, cause microsoft is
nice
like that.

Any none complicated ideas???

Thanking you all in advance

Sweetie

Dont think i explained myself very well, that or im just getting blonder with
age.

In cell L10, i have a expirey date (12/12/2008), in M10, i want the number
of days left till its expired showing, and of course updating everyday.......
I knowthis can be done, i have seen it, just dont now how to do it....

I please forgive me if thats what you all have shown me so far, im just not
getting it....

"David Biddulph" wrote:

Or use =A1-TODAY()
Note that you get a day's difference because of the truncation of the
non-integer part after subtracting NOW(), so decide whether you want the
count of days to be inclusive or not.
--
David Biddulph

"Joel" wrote in message
...
the date is =now()

the number of days until expiration is

A1 = 10/1/08
Expiration is
= int(A1-Now())

if yo want to combine them in a cell
="Expiration : "&TEXT(A1,"mm/dd/yy")&"; Days Until Expiration :
"&INT(A1-NOW())
"Sweetie" wrote:

Hi guys/Gals

Im desperatly trying to work out how to put a countdown on a excel sheet
for
things that are due to expire.
I have a hundred and one uses for this, but for love or money I cant get
it
right.

I need the Expire date showing, along with the number of days till
experation, and of course, this would up date daily, cause microsoft is
nice
like that.

Any none complicated ideas???

Thanking you all in advance

Sweetie

OK OK OK

The blonde has been washed out, i changed the cell to general and its now
in full working order,

Thank you for all your help.

"Sweetie" wrote:

Hi guys/Gals

Im desperatly trying to work out how to put a countdown on a excel sheet for
things that are due to expire.
I have a hundred and one uses for this, but for love or money I cant get it
right.

I need the Expire date showing, along with the number of days till
experation, and of course, this would up date daily, cause microsoft is nice
like that.

Any none complicated ideas???

Thanking you all in advance

Sweetie