[ikthius]

hey everyone....

trying to get a small thing working.

what I am trying is to have an if statement working.

I have a column of start dates and a column of end dates.

I want to have a week 1 show if todays date falls in between these dates.

ok it works as a one off, but in a full formula it does not.

A1: 22 oct 07 A2: =sum(A1+7) etc
B1: 28 oct 07 B2: =sum(B1+7) etc
C1: =today() will always stay the same cell

formula:
=if($C$1>=A1&$C$1<=B1,"Week 1","")

ok say I got 10 rows I should only expect one row to show what week it is, each formula will go up in weeks.

why this not work?

ik