I want to use a different cell if my date field is NULL/BLANK
 

I have 3 date fields:

STARTDTE ENDDTE REVDTE
08/22/2007 12/15/2007 If REVDTE NULL use STARTDTE
08/22/2007 12/15/2007 09/01/2007 If REVDATE NOT NULL use REVDTE

There will always be a date in the STARTDTE & ENDDTE cells. These are the
dates to be used if REVDTE is "NULL". If REVDTE is NOT NULL (contains a date)
use this date in the calculation.

Thanks in advance
Ralph

I want to use a different cell if my date field is NULL/BLANK
 

Ralph

sorry, use the dates in what calculation ?

Something like:

=IF(REVDTE<"",REVDTE,STARTDTE)

Regards

Trevor


"Ralph D''Andrea" wrote in message
...
I have 3 date fields:

STARTDTE ENDDTE REVDTE
08/22/2007 12/15/2007 If REVDTE NULL use
STARTDTE
08/22/2007 12/15/2007 09/01/2007 If REVDATE NOT NULL use REVDTE

There will always be a date in the STARTDTE & ENDDTE cells. These are the
dates to be used if REVDTE is "NULL". If REVDTE is NOT NULL (contains a
date)
use this date in the calculation.

Thanks in advance
Ralph

I want to use a different cell if my date field is NULL/BLANK
 

Trevor,
Sorry if I didn't clearly explain.

If REVDTE is BLANK/NULL
ENDDTE - STARTDTE = # days for assignment
else
ENDDTE - REVDTE = # days for assignment
endif

Thanks in advance,
Ralph

"Trevor Shuttleworth" wrote:

Ralph

sorry, use the dates in what calculation ?

Something like:

=IF(REVDTE<"",REVDTE,STARTDTE)

Regards

Trevor


"Ralph D''Andrea" wrote in message
...
I have 3 date fields:

STARTDTE ENDDTE REVDTE
08/22/2007 12/15/2007 If REVDTE NULL use
STARTDTE
08/22/2007 12/15/2007 09/01/2007 If REVDATE NOT NULL use REVDTE

There will always be a date in the STARTDTE & ENDDTE cells. These are the
dates to be used if REVDTE is "NULL". If REVDTE is NOT NULL (contains a
date)
use this date in the calculation.

Thanks in advance
Ralph

I want to use a different cell if my date field is NULL/BLANK
 

Ralph

You've actually nearly written it:

=IF(REVDTE="" , ENDDTE - STARTDTE , ENDDTE - REVDTE)

Regards

Trevor


"Ralph D''Andrea" wrote in message
...
Trevor,
Sorry if I didn't clearly explain.

If REVDTE is BLANK/NULL
ENDDTE - STARTDTE = # days for assignment
else
ENDDTE - REVDTE = # days for assignment
endif

Thanks in advance,
Ralph

"Trevor Shuttleworth" wrote:

Ralph

sorry, use the dates in what calculation ?

Something like:

=IF(REVDTE<"",REVDTE,STARTDTE)

Regards

Trevor


"Ralph D''Andrea" wrote in
message
...
I have 3 date fields:

STARTDTE ENDDTE REVDTE
08/22/2007 12/15/2007 If REVDTE NULL use
STARTDTE
08/22/2007 12/15/2007 09/01/2007 If REVDATE NOT NULL use
REVDTE

There will always be a date in the STARTDTE & ENDDTE cells. These are
the
dates to be used if REVDTE is "NULL". If REVDTE is NOT NULL (contains a
date)
use this date in the calculation.

Thanks in advance
Ralph

I want to use a different cell if my date field is NULL/BLANK
 

I appreciate your responce.
I came from a programming background, sometimes it helps......

It works great.....thanks
RAlph

Thanks,

"Trevor Shuttleworth" wrote:

Ralph

You've actually nearly written it:

=IF(REVDTE="" , ENDDTE - STARTDTE , ENDDTE - REVDTE)

Regards

Trevor


"Ralph D''Andrea" wrote in message
...
Trevor,
Sorry if I didn't clearly explain.

If REVDTE is BLANK/NULL
ENDDTE - STARTDTE = # days for assignment
else
ENDDTE - REVDTE = # days for assignment
endif

Thanks in advance,
Ralph

"Trevor Shuttleworth" wrote:

Ralph

sorry, use the dates in what calculation ?

Something like:

=IF(REVDTE<"",REVDTE,STARTDTE)

Regards

Trevor


"Ralph D''Andrea" wrote in
message
...
I have 3 date fields:

STARTDTE ENDDTE REVDTE
08/22/2007 12/15/2007 If REVDTE NULL use
STARTDTE
08/22/2007 12/15/2007 09/01/2007 If REVDATE NOT NULL use
REVDTE

There will always be a date in the STARTDTE & ENDDTE cells. These are
the
dates to be used if REVDTE is "NULL". If REVDTE is NOT NULL (contains a
date)
use this date in the calculation.

Thanks in advance
Ralph

I want to use a different cell if my date field is NULL/BLANK
 

You're very welcome. Thanks for the feedback.


"Ralph D''Andrea" wrote in message
...
I appreciate your responce.
I came from a programming background, sometimes it helps......

It works great.....thanks
RAlph

Thanks,

"Trevor Shuttleworth" wrote:

Ralph

You've actually nearly written it:

=IF(REVDTE="" , ENDDTE - STARTDTE , ENDDTE - REVDTE)

Regards

Trevor


"Ralph D''Andrea" wrote in
message
...
Trevor,
Sorry if I didn't clearly explain.

If REVDTE is BLANK/NULL
ENDDTE - STARTDTE = # days for assignment
else
ENDDTE - REVDTE = # days for assignment
endif

Thanks in advance,
Ralph

"Trevor Shuttleworth" wrote:

Ralph

sorry, use the dates in what calculation ?

Something like:

=IF(REVDTE<"",REVDTE,STARTDTE)

Regards

Trevor


"Ralph D''Andrea" wrote in
message
...
I have 3 date fields:

STARTDTE ENDDTE REVDTE
08/22/2007 12/15/2007 If REVDTE NULL
use
STARTDTE
08/22/2007 12/15/2007 09/01/2007 If REVDATE NOT NULL use
REVDTE

There will always be a date in the STARTDTE & ENDDTE cells. These
are
the
dates to be used if REVDTE is "NULL". If REVDTE is NOT NULL
(contains a
date)
use this date in the calculation.

Thanks in advance
Ralph