Thread: Formula Help
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Sheila D Sheila D is offline
external usenet poster
 
Posts: 65
Default 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