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