Formulas affecting Formulas?

[JakeMann]

Hiya,

On the attached sheet I have a page called 'Week' that shows dates. Previously I have been able to match those dates and generate a list with the following formula on page 'Formula'.

=IF(OR(E2=Week!$B$2,E2=Week!$B$3,E2=Week!$B$4,E2=Week!$B$5,E2=Week!$B$6,),COUNT(G$1:G1)+1,"")

For some reason it won't display anything and I'm wondering whether it's to do with the formula it's table it's reading from on page 'Intouch'.

[JakeMann]

Just as a test I changed the formula in column E of the 'Formula' page to text and the formula worked so it would seem that formula's do affect the outcome.

[Ace_XL]

Consider changing your formula in 'Intouch' tab to

Please Login or Register  to view this content.

Currently the result is read as text and not as a date, hence the anomaly

[Pepe Le Mokko]

The formula you are using in the INTOUCH sheet (LEFT...) extracts a text string which you are comparing to a number of the Weeks sheet. Thus it always returns an empty string

Enter

Please Login or Register  to view this content.

in ED2 (then drag down) in the Intouch sheet and format as date. You will see your results now appearing

[JakeMann]

Thankyou both,

Both of those examples have worked