.... or, more simply, =A2+(C2<B2)
--
David Biddulph

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
=IF(C2B2,A2,A2+1)
--
David Biddulph

"Mayte" wrote in message
...
is there any way to use a formula in column D (Close Date) that will give
you
the close date?? For insrtance

IF I have a "Close Time" that is for the same day ...File "Open Time" is
at
11:50PM and "Close Time" is at 11:58PM, the "Close Date" would be the
same as
the "Open date" (06/01/08)

BUT ...IF the "Close Time" is the next day .... File "Open Time" is at
11:55PM and the "Close Time" is at 1:00AM (next day), the "Close Date"
would
be 06/03/08

Open Date Open Time Close Time Close Date
06/01/08 11:50 PM 11:58 PM 06/01/08
06/02/08 11:55 PM 1:00 AM 06/03/08

any ideas would be greatly appreciate it !!

cheers,
mayte