| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| OFFSET and array formulae | Excel Discussion (Misc queries) | |||
| Offset and Indirect functions | Excel Discussion (Misc queries) | |||
| Offset, indirect, match function limitation on linked worksheets. | Excel Worksheet Functions | |||
| Passing Cell Address to Offset | Excel Worksheet Functions | |||
| Offset? | Excel Discussion (Misc queries) | |||
Threaded Mode
