Formula Help

[Guest]

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

 

[Bill Ridgeway]

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

 

[Guest]

Something like =A2+B2-NOW() which assumes your date in A2, number of days in
B2 - HTH

Sheila
www.c-i-m-s.com

 

[Guest]

Thanks for the replies.

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