I'm trying to set up a date formula generating a date in Column E,
based on dates in Columns A & B.
Col. E is supposed to be 15 months after Column A+60 days, or Column
B, depending on which date is the earlier.
I set up a formula at the office, but when Column B is empty, there's
a 1900 date in Column D and I'd like to have that Column blank until
there are values in Column B.
Any ideas.?


Israel Rodriguez

http://home.earthlink.net/~isrodriguez7/

Hi Israel!

Here's the basic structu
=IF(B1="","",YourFormula)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

On Tue, 27 Jan 2004 16:58:13 +1100, "Norman Harker"
wrote:

Hi Israel!

Here's the basic structu
=IF(B1="","",YourFormula)

I tried it but it didn't work.
My original formula was:
=IF(F3+60<=G3,edate(F3,15),edate(G3,15))



Israel Rodriguez

http://home.earthlink.net/~isrodriguez7/

Hi Israel!

If it's F3 that's possibly empty:

=IF(F3="","",IF(F3+60<=G3,edate(F3,15),edate(G3,15 )))

If it's G3 that's possibly empty:

=IF(G3="","",IF(F3+60<=G3,edate(F3,15),edate(G3,15 )))

If you want to cover either F3 or F3 being empty:

=IF(COUNTA(F3:G3)<2,IF(F3+60<=G3,edate(F3,15),edat e(G3,15)))


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.