The cell referencing would be OK if, as you copy the formula across, you
still want the formula to refer to cell B1, so that each week's column will
be populated as if it were week 1.
I'd be surprised if that's what you want.
--
David Biddulph

"Grey Old Man" wrote in message
...
It's my logic =IF(AND( ....,....),"Y","N") that is flawed. The cell
referencing is OK.

"David Biddulph" wrote:

You haven't told us how it fails, but:

B$1, rather than $B$1, so that it copies across appropriately ?
--
David Biddulph

"Grey Old Man" wrote in message
...
I can obtain the current year with YEAR(TODAY()) and the current week
number
with WEEKNUM, but I want to display the results in an ?array. By this I
mean;
row 1 contains the week nos 1 -52; column A contains the years
2010,2009,2008.
I want the result to look like:

2010 N N N -----N until week 52
2009 Y Y Y ------ Y until current week, then N N N until week 52
2008 Y Y Y ------ Y until week 52

My current attempt fails, which is
=IF(AND(Current_Year=$A2,Current_Week=$B$1),"Y", "N")

The purpose is to automatically populate a chart (graph) with current
data
(Y) and ignore future data (N). Thanks in anticipation.




.