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

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

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

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