I am trying to make formula for two conditions on column C to get the
bednights.
=if (isblank (b4) ,1,0) and =if(b4<=C2,1,0).

1 A B C
2 ENTER DATE "EXITDATE" 07/01/09
3 Bednights
4 10/9/2008 07/15/09 1
5 10/9/2008 07/15/09 1
6 10/9/2008 07/15/09 1
7 10/9/2008 07/15/09 1
8 12/17/2008 1

Appreciate any help.

Thanks,

Jina