Quote:
Originally Posted by TheNorm
What is the purpose of "A1&$C$1"?
|
did I not try and explain it???
ok column A has a row of start dates like monday one week
column B has a row of end dates say sunday
but C1 is today as in the formula =TODAY() so this updates all the time.
so I made this the same cell to be referenced all the time e.g. $C$1
I want to see if cell C1 is between A1 and B1.
ik
thats it, I was trying to combine it with an & operand