need more help with formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to add the values in cells K14 & L14 if cell DE14 is blank or the date
in it falls within a range (for example 05/01/05 & 03/31/05). If the
condition is not met, the entry should be zero. Can anyone help me with this?
 
Wayne,

Try:

=IF(OR(DE14="",AND(DE14<DATE(2005,6,1),DE14>=DATE(2005,3,1))),K14+L14,0)

HTH,
Ryan
 
=IF(OR(DE14="",AND(DE14>=DATE(2005,3,31),DE14<=DATE(2005,5,1))),K14+L14,0)

If you put the target dates in cells, say A1 and B1, it's simpler:

=IF(OR(DE14="",AND(DE14>=A1,DE14<=B1)),K14+L14,0)
 
Back
Top