Criteria Serach

I

Ify

Hi dear,

Many thanks for your help.

Any idea what is wrong with this two formulas ,please?

=IF('[aspi-ho of -acidjul.xls]asp
rec-30-07-07'!$E$2:$E$4041>=DATE(2004,4,1),IF('[aspi-ho o
-acidjul.xls]asp
rec-30-07-07'!$E$2:$E$4041<=DATE(2005,5,31),IF(A6='[aspi-ho o
-acidjul.xls]aspi rec-30-07-07'!$A$3:$A$4041,'[aspi-ho o
-acidjul.xls]aspi rec-30-07-07'!$E$2:$E$4041,TEXT($F$3,"dd/mm/04"))))


AND

=IF('[aspi-ho of -acidjul.xls]asp
rec-30-07-07'!$E$2:$E$4041>=DATE(2004,4,1),IF('[aspi-ho o
-acidjul.xls]asp
rec-30-07-07'!$E$2:$E$4041<=DATE(2005,5,31Vlookup(a6,,'[aspi-ho o
-acidjul.xls]aspi rec-30-07-07'!$A$2:$E$4041,5,FALSE))

The purpose is to pick up the dates that fall in between those tw
giving dates else to pick up the first giving date of 01/04/04 in th
format specified.

Thank you
 
Top