Workday Function Counting Holidays on Another Sheet

Trying to make a function where it counts holidays referenced on another sheet. The formula I am using is =WORKDAY([Test Out Date]@row, 30, {Reference Sheet Column Location}) and I am getting an "Invalid Data Type" error

Any idea what I need to do? I dont want to include my holidays on the same sheet cause it messes up other formulas

Thanks

Find more posts tagged with

Formulas

Accepted answers

Genevieve P.

Hi @Austin Whisenant

What column type are you putting the formula into? The formula would need to be placed into a Date type of column in order to return a date. This should resolve the Invalid Data Type error!

Let me know if this works for you.

Cheers,

Genevieve

All comments

Genevieve P.

Hi @Austin Whisenant

What column type are you putting the formula into? The formula would need to be placed into a Date type of column in order to return a date. This should resolve the Invalid Data Type error!

Let me know if this works for you.

Cheers,

Genevieve

Austin Whisenant

That did it! Much appreciated

Thank ya

Genevieve P.

Wonderful! I'm glad I could help.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.