ExcelBanter - Offset with Cell("address")

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Offset with Cell("address") (https://www.excelbanter.com/excel-worksheet-functions/7584-offset-cell-%22address%22.html)

James W.

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

Peo Sjoblom

Because it will retun text, to overcome that you would need to use INDIRECT
however once you do it will create a circular reference

Regards,

Peo Sjoblom

"James W." wrote:

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

All times are GMT +1. The time now is 07:08 PM.