Help with Edate Formula

  • Thread starter Thread starter Israel Rodriguez
  • Start date Start date
I

Israel Rodriguez

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 structure:
=IF(B1="","",YourFormula)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
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),edate(G3,15)))


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top