Nested IF or( If And ) can't get it to work

[John]

HI Everyone
I'm working on a Vacation Planner and just can't get it to work.
E6 and F6 are dates, G6 is the total of days from F6-E6.
The formula below seems to work except when the cell is empty its still
giving me a count of 1 in G6.
=IF(AND(E6="Half Day",F6>1),0.5,IF(AND(E6<1,F6>1),1,F6-E6+1))
From To Qty
E6 F6 G6
12/08/2008 20/08/2008 19 OK starting date included
Empty 20/08/2008 1 OK
Half Day 20/08/2008 0.5 OK
Empty Empty I'm getting 1 Not ok
I tried different IF function but I can't get 4 condition working
I would appreciate some help please
Thank you
John

 

[Bob Phillips]

=IF(AND(E6="",F6=""),"",IF(AND(E6="Half
Day",F6>1),0.5,IF(AND(E6<1,F6>1),1,F6-E6+1)))

 

[John]

Thank you very much Bob
Believe it or not I tried it more then once and could not get it to work,
I must of screwed up on the syntax, and spent hours trying to get it to
work.
Regards
John