Conditional formatting if weeknum is different

Copper Contributor

Hello i like to have conditional formatting on my excel if numer of week on column G (start row 8) is different from actually week numer. 

 

For example today we are on weeknumer 7. 

I need to formatting and lock if numer is differet. I try this formula but not working 

=weeknumber($G8)<>weeknumber(today())

 

But not work. This is my sheet 

INFOCHECKWK
  1
  2
  3
  4
  5
  6
  7
  8
  9
  10
2 Replies

@lifesafari Try this:

=G8<>WEEKNUM(TODAY())

 

WEEKNUMBER is not a valid Excel function!

See attached.

@lifesafari 

Use WEEKNUM instead of weeknumber:

 

=WEEKNUM($G8)<>WEEKNUM(TODAY())