Workday Function Counting Holidays on Another Sheet

Austin Whisenant

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

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

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.