Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 16
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,089
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 16
Default 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




  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,089
Default 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






  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 16
Default 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








  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,089
Default 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








Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
If null, make cell blank Nicole L. Excel Worksheet Functions 1 September 30th 07 08:25 AM
Date Formula Problem - Leave date blank if Null Gayla Excel Worksheet Functions 5 April 24th 07 09:42 PM
COUNTIF says Null = Blank but Blank < Null Epinn Excel Worksheet Functions 4 October 25th 06 08:03 PM
Linked date field in worksheet defaults a blank field as 1/0/1900 AmnNkD Excel Worksheet Functions 2 September 12th 06 05:42 PM
Replace null string with blank cell gjcase Excel Discussion (Misc queries) 2 August 9th 05 02:13 PM


All times are GMT +1. The time now is 04:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"