| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF and Date Functions
I want to have a "date due" to be 7 days after the "date out" unless the
student option=true, then I want the "date due" to be 1 day after the "date out." This is what i have so far: =IF(G3=True,D3+1,D3+7) This function works EXCEPT that until a date is entered in the "date out" cell, the "date due" reads 1/7/1900. I want the "date due" to be blank until a date is entered into the "date out" cell. HELP! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF and Date Functions
=IF(G3=True,D3+1,D3+7)
Just add a front IF check so that the orig. formula evaluates only if both D3 and G3 contain something, viz.: =IF(OR(D3="",G3=""),"",IF(G3=TRUE,D3+1,D3+7)) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Christ4" wrote: I want to have a "date due" to be 7 days after the "date out" unless the student option=true, then I want the "date due" to be 1 day after the "date out." This is what i have so far: =IF(G3=True,D3+1,D3+7) This function works EXCEPT that until a date is entered in the "date out" cell, the "date due" reads 1/7/1900. I want the "date due" to be blank until a date is entered into the "date out" cell. HELP! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF and Date Functions
THANK YOU - FRUSTRATION OVER!!!!!!!!!!!!!!!! Worked great.
G "Max" wrote: =IF(G3=True,D3+1,D3+7) Just add a front IF check so that the orig. formula evaluates only if both D3 and G3 contain something, viz.: =IF(OR(D3="",G3=""),"",IF(G3=TRUE,D3+1,D3+7)) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Christ4" wrote: I want to have a "date due" to be 7 days after the "date out" unless the student option=true, then I want the "date due" to be 1 day after the "date out." This is what i have so far: =IF(G3=True,D3+1,D3+7) This function works EXCEPT that until a date is entered in the "date out" cell, the "date due" reads 1/7/1900. I want the "date due" to be blank until a date is entered into the "date out" cell. HELP! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF and Date Functions
Glad that de-stressor worked <g !
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Christ4" wrote: THANK YOU - FRUSTRATION OVER!!!!!!!!!!!!!!!! Worked great. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| Date Functions | Excel Discussion (Misc queries) | |||
| Help with Date Functions | Excel Worksheet Functions | |||
| date functions | Excel Discussion (Misc queries) | |||
| Date functions for dates pre-1900 | Excel Discussion (Misc queries) | |||
Linear Mode
