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

[Ralph D''Andrea]

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

 

[Trevor Shuttleworth]

Ralph

sorry, use the dates in what calculation ?

Something like:

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

Regards

Trevor

 

[Ralph D''Andrea]

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]

Ralph

You've actually nearly written it:

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

Regards

Trevor

 

[Ralph D''Andrea]

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

It works great.....thanks
RAlph

Thanks,

 

[Trevor Shuttleworth]

You're very welcome. Thanks for the feedback.

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

It works great.....thanks
RAlph

Thanks,