Hello,

I would like to know how to set a formula to check two cells for dates and
then calculate a start date by taking one of those cells and adding lead days
from another cell. The hard part is making the formula 1) check the
confirmed cell for a date and if no date there then 2) use tentative date.

My spreadsheet is like follows:

G2 = tentative project start date
I2 = confirmed project start date
D2 = lead time (usually 45, 60 or 90 days)
E2 = PreWork Start Date

So I need the formula to:
1) check I2 for a date, if this cell has a date then in cell E2 I need the
answer to 'I2-D2'
2) if I2 has no date then use date in G2. So in cell E2 I need answer to
'G2-D2'

I've tried this:

=IF(OR(LEN(I22)=0),AND(G22-D22),AND(I22-D22))

but the formula gives me True, I need a date. please help.


--
Thank You!