View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default Expire count down

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