Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If null, make cell blank | Excel Worksheet Functions | |||
Date Formula Problem - Leave date blank if Null | Excel Worksheet Functions | |||
COUNTIF says Null = Blank but Blank < Null | Excel Worksheet Functions | |||
Linked date field in worksheet defaults a blank field as 1/0/1900 | Excel Worksheet Functions | |||
Replace null string with blank cell | Excel Discussion (Misc queries) |