Please help before I go insane looking at this formula!!
On one tab, I have a cell which contains the following formula; I have named this cell "EndofMonth". And the cell is formatted as a number.
=TEXT(EOMONTH(G8,0),"YYYYMMDD")
(G8 being a date entered by the user e.g. 10/06/2008)
In a seperate tab I have a relatively simple If(and( formula which has several criteria. I have tested each criteria seperately and the problem lies where I am using this named range (EndofMonth) However I will paste the whole formula for completeness:
=IF(AND(RawDate58=0,RawDelDate<=Month25,RawCDD>EndofMonth,RawCDD<EndofYear,RawFON<>"11885", RawFON<>"17858"),1,0)
When I replace the named range EndofMonth with 20080630 the formula works fine - any ideas?!!
p.s. The cells it is referring to (e.g. RawCDD, RawDate58 are all formatted as number)
On one tab, I have a cell which contains the following formula; I have named this cell "EndofMonth". And the cell is formatted as a number.
=TEXT(EOMONTH(G8,0),"YYYYMMDD")
(G8 being a date entered by the user e.g. 10/06/2008)
In a seperate tab I have a relatively simple If(and( formula which has several criteria. I have tested each criteria seperately and the problem lies where I am using this named range (EndofMonth) However I will paste the whole formula for completeness:
=IF(AND(RawDate58=0,RawDelDate<=Month25,RawCDD>EndofMonth,RawCDD<EndofYear,RawFON<>"11885", RawFON<>"17858"),1,0)
When I replace the named range EndofMonth with 20080630 the formula works fine - any ideas?!!
p.s. The cells it is referring to (e.g. RawCDD, RawDate58 are all formatted as number)
