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!

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!

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!

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.