Expire count down

[Sweetie]

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

 

[Stefi]

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

Regards,
Stefi

„Sweetie†ezt írta:

 

[Joel]

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())

 

[David Biddulph]

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.

 

[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....

 

[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.