# Workday formula

Options
✭✭✭

I have a workday formula in place now which calculates an expected due date from the date of submission. I've checked the results and find that the calculations are off by 10 days.

The expected date should be a combination of two SLAs.

The first calculating the due date from the submitted date using a department SLA of 2

The second calculating from the Stakeholder Turnover date using a department B SLA of either 20 or 10

The original formula reads as follows:

=WORKDAY(submitted@row,SLA@row)

The second I wanted to use is below and I get unparseable.

=WORKDAY([Submitted@row], GPGSLA@row,[DepartmentB@row],SLA@row))

The GPG SLA is 2 and Department B SLA is either 20 or 10

Any ideas to make this work? Appreciate any insight you can give me.

Thank you very much,

YCRock

• ✭✭✭✭✭✭
Options

So basically

[GPG SLA]@row + SLA@row

?

Then added to the Submitted Date?

=WORKDAY(Submitted@row, [GPG SLA]@row + SLA@row)

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

• ✭✭✭✭✭✭
Options

Are you able to provide some screenshots for context?

• ✭✭✭
Options

The submitted date is when the request was first received. The expected due date was calculated as 1/23/23

The column SLA is based on a secondary stakeholder's approval schedule. There are two options 20, 10.

The Column GPG SLA was added. They need two days to review before passing to the secondary approver. When their review is complete, they mark approved and the Stakeholder Date is populated by automation's "Record a date." function.

Expected due date should be a combination of the GPGSLA and the Stakeholder Date start (if you will).

Thank you very much,

YCRock

• ✭✭✭✭✭✭
Options

So basically

[GPG SLA]@row + SLA@row

?

Then added to the Submitted Date?

=WORKDAY(Submitted@row, [GPG SLA]@row + SLA@row)

• ✭✭✭
Options

I tried that and received unparseable. Maybe I missed the comma. Thanks a bunch! I'll try it now. It worked! Thank you again! I didn't have the comma in the right place.

Thank you very much,

YCRock

• ✭✭✭✭✭✭