|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 27th, 2009, 03:11 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
Showing how much longer for a due date.
I am trying to figure out how to show how much longer someone will have to
send a product back if they only have 30 days to return it. I would like the cell to count down from 30-1 and show colors at different stages. Is this possible or am I asking too much? 
|
|
#2
February 27th, 2009, 12:23 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Showing how much longer for a due date.
Dear,
You need to be more specific on this. Is there any date element associated with this or you are going to enter the date on which someone returns the product back on the scale of 1 to 30 days. Thanks -- Dilip Kumar Pandey MBA, BCA, B.Com(Hons.) New Delhi, India "daddyr" wrote: I am trying to figure out how to show how much longer someone will have to send a product back if they only have 30 days to return it. I would like the cell to count down from 30-1 and show colors at different stages. Is this possible or am I asking too much?
|
|
#3
February 28th, 2009, 04:59 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Showing how much longer for a due date.
Hi, If your delivered date is in A1,then something like this =IF(TODAY()A1+30,"Out of Time","Days left "&A1+30-TODAY()) -- oldchippy ------------------------------------------------------------------------ oldchippy's Profile: http://www.thecodecage.com/forumz/member.php?userid=111 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=69451
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
