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",F61),0.5,IF(AND(E6<1,F61),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