Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help
Looking for a formula that shows days left to comply to something.
So lets say column A has a date of 1/01/06 and we have 30 days to do something. So in column B Id like to show how many days left before the 30th day. So Lets say todays 1/20/06 so column B should have 10 days left to comply. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help
I would suggest you set it out as follows-
Column A Column B Column C Column D Source No (of days) Target Status User input User =A2+B2 =IF(TODAY()C2,"Expired",C2-TODAY()) Regards. Bill Ridgeway Computer Solutions "Str8" wrote in message ... Looking for a formula that shows days left to comply to something. So let's say column A has a date of 1/01/06 and we have 30 days to do something. So in column B I'd like to show how many days left before the 30th day. So Lets say today's 1/20/06 so column B should have "10 days" left to comply. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help
Something like =A2+B2-NOW() which assumes your date in A2, number of days in
B2 - HTH Sheila www.c-i-m-s.com "Str8" wrote: Looking for a formula that shows days left to comply to something. So lets say column A has a date of 1/01/06 and we have 30 days to do something. So in column B Id like to show how many days left before the 30th day. So Lets say todays 1/20/06 so column B should have 10 days left to comply. Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help
Thanks for the replies.
"Bill Ridgeway" wrote: I would suggest you set it out as follows- Column A Column B Column C Column D Source No (of days) Target Status User input User =A2+B2 =IF(TODAY()C2,"Expired",C2-TODAY()) Regards. Bill Ridgeway Computer Solutions "Str8" wrote in message ... Looking for a formula that shows days left to comply to something. So let's say column A has a date of 1/01/06 and we have 30 days to do something. So in column B I'd like to show how many days left before the 30th day. So Lets say today's 1/20/06 so column B should have "10 days" left to comply. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |