Skip to main content
Documentation
Documentation
Workday User Guide
Last Updated: 2023-06-23
OFFSET

OFFSET

Description

Returns a range of cells that is offset by a specified number of rows and columns from the original reference. This function is volatile; it generates a new value any time any cell in the workbook changes.

Syntax

OFFSET(
reference
,
rows
,
cols
, [
height
], [
width
])
  • reference
    : The range of cells to return the offset for.
  • rows
    : The number of rows to offset the range by.
  • cols
    : The number of columns to offset the range by.
  • height
    : The height of the range to return.
  • width
    : The width of the range to return.

Notes

  • The function doesn't run as a volatile function if the Worksheets calculation mode is set to
    Manual
     in
    File
    Settings
     .
  • If you don't include the
    height
     and
    width
     arguments, the function returns the same height and width as the
    reference
    .
  • If you use OFFSET as a stand-alone formula and the result contains a range instead of a single cell, you must enter the function as an array formula.

This content is not part of the Workday Administrator Guide.