View Single Post
  #1   Report Post  
James W.
 
Posts: n/a
Default Offset with Cell("address")

Why won't this work...
=offset(CELL("address"),1,1)-WEEKDAY(offset(CELL("address"),1,1),3)
I am trying to return mondays date depending on what's in cell
offset(activecell,1,1)

Thanks in advance