Home |
Search |
Today's Posts |
#1
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
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
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dates in cells are no longer visable but are showing as ######## | Excel Discussion (Misc queries) | |||
date formated as date showing as number | Excel Discussion (Misc queries) | |||
Date showing incorrect. 30:00 hrs showing 06:00 | Excel Discussion (Misc queries) | |||
Showing last editing date | Excel Discussion (Misc queries) | |||
Showing date last saved | Excel Discussion (Misc queries) |