Workday Formula

Georgina Thurlow

Hi All,

Not sure what I am doing wrong here, but the Workday formula does not seem to work when selecting multiple holidays and results in "#INVALID DATA" error. The formula works if I just select one bank holiday but errors with multiple. I have attached a screenshot - any help gratefully received!

Georgina

Workday Smartsheet.JPG

Paul Newcome

Make sure all of the bank holiday columns are formatted as date type columns. Also make sure that the values within those cells are actual dates and not text strings that just look like dates.

Paul Newcome

Make sure all of the bank holiday columns are formatted as date type columns. Also make sure that the values within those cells are actual dates and not text strings that just look like dates.