Hi Mark:
I thinking if you set a static number in one cell, say 39,000. Then have a
second cell return the now function returning today value rounded
accordingly. Then finally a third cell subtracting the previous two cells.
Are you following me? Let me know, if not. This should work with the round
functions or abs function depending on what you want. Also watch your cell
format.
Richard F. Bolha
> [Original Message]
> From: Mark Rode <[log in to unmask]>
> To: <[log in to unmask]>
> Date: 8/6/2006 8:51:35 PM
> Subject: [PCSOFT] Excel Declining Number
>
> Does anyone know a formula that will reduce a defined number by one,
every
> 24 hours, or better at 00hrs ? I trying to make a cell count down imputed
> days automatically.
>
> Thanks
> Mark Rode
>
> "Hold No Punches.." Rode brings you great shareware/freeware
> programs with his honest opinions in this weekly column.
> http://freepctech.com/rode
>
> __________ NOD32 1.1694 (20060805) Information __________
>
> This message was checked by NOD32 antivirus system.
> http://www.eset.com
>
PCSOFT maintains many useful files for download
visit our download web page at:
http://freepctech.com/downloads.shtml
|