Prev: Index, Match help
Next: first some general questions about populating...
From: Bob Phillips on 3 Apr 2010 06:03
Nor do I, but I didn't mean to add that level of um sophistication for
someone who is clearly relatively new to Excel. The amended form is much
clearer in intent.

--

HTH

Bob

"Teethless mama" <Teethlessmama(a)discussions.microsoft.com> wrote in message
news:BA401A87-BE21-4A2C-98B9-F9E5301D6B84(a)microsoft.com...
>> Typo, should be
>> =IF(B2<>"",B2-A2,TODAY()-A2)
>
>
> I don't see anything wrong with your previous answer
>> =IF(B2,B2-A2,TODAY()-A2)
>
>
>
> "Bob Phillips" wrote:
>
>> Typo, should be
>>
>> =IF(B2<>"",B2-A2,TODAY()-A2)
>>
>>
>> --
>>
>> HTH
>>
>> Bob
>>
>> "Bob Phillips" <bob.phillips(a)somewhere.com> wrote in message
>> news:uuG5D2o0KHA.840(a)TK2MSFTNGP06.phx.gbl...
>> >
>> > Does the second date automatically mean that the status is also set? If
>> > so, you only need
>> >
>> > =IF(B2,B2-A2,TODAY()-A2)
>> >
>> > --
>> >
>> > HTH
>> >
>> > Bob
>> >
>> > "Pat" <Pat(a)discussions.microsoft.com> wrote in message
>> > news:4BAA9E91-9FB0-452D-929E-D75C3C64C047(a)microsoft.com...
>> >> (Excel 2003) Is there a way to calculate the days and then stop the
>> >> counting
>> >> when you have entered a completion date and/or cancelled appears in
>> >> the
>> >> "Status column?
>> >>
>> >> I want the duration column to keep calculating the days until either a
>> >> date
>> >> is enter into the "Completion Date" Column or the "Status" Column has
>> >> cancelled or completed in it.
>> >>
>> >> Start Date Completion Date Status Duration
>> >> 3/24/10
>> >> 9
>> >>
>> >> 3/15/10 3/20/10 Cancelled 5
>> >>
>> >> --
>> >> pls
>> >
>> >
>>
>>
>> .
>>


First  |  Prev  | 
Pages: 1 2
Prev: Index, Match help
Next: first some general questions about populating...