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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Ralph

sorry, use the dates in what calculation ?

Something like:

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

Regards

Trevor
 
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
 
Ralph

You've actually nearly written it:

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

Regards

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

It works great.....thanks
RAlph

Thanks,
 
You're very welcome. Thanks for the feedback.


Ralph D''Andrea said:
I appreciate your responce.
I came from a programming background, sometimes it helps......

It works great.....thanks
RAlph

Thanks,
Click to expand...
 
Back
Top