Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Count-down timer? (e.g. 10 days left...9...8...)
Is there a way to program a count-down timer in Excel?
For example, say I need to buy toner cartridges every 3 months, and I just bought some. Then I can reset the timer, and it'll indicate another 3 months. When the three months are up, another cell will turn go from "Toner in stock" to "Buy toner." Does anyone know how to program excel to do something like this? Thanks! |
#2
|
|||
|
|||
I wish.
all forms have a timer event but unfortunately it can be use only on 1 event. some of my users are buyers and they have requested this also but the most i can do is use the info they put in the system to generate a report that has a "buy by" date and i sort this date to the top so all of the items that we aare low on are sort to the top.(do me first) -----Original Message----- Is there a way to program a count-down timer in Excel? For example, say I need to buy toner cartridges every 3 months, and I just bought some. Then I can reset the timer, and it'll indicate another 3 months. When the three months are up, another cell will turn go from "Toner in stock" to "Buy toner." Does anyone know how to program excel to do something like this? Thanks! . |
#3
|
|||
|
|||
Hi
Enter the date in cell A1 everytime you change toner. If toner last 90 days then use this formula in cell B1 =(A1+90-TODAY())&" days left" HTH. Best wishes Harald "mesotech" skrev i melding ... Is there a way to program a count-down timer in Excel? For example, say I need to buy toner cartridges every 3 months, and I just bought some. Then I can reset the timer, and it'll indicate another 3 months. When the three months are up, another cell will turn go from "Toner in stock" to "Buy toner." Does anyone know how to program excel to do something like this? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I make a calendar with every three days a different color . | Excel Discussion (Misc queries) | |||
how do I make a calendar with every three days a different color . | Excel Discussion (Misc queries) | |||
Calculating Production/Man Days in Excel | Excel Discussion (Misc queries) | |||
How would I change a date cell to decrease it by business days? | Excel Discussion (Misc queries) | |||
filter and count | Excel Discussion (Misc queries) |