Workday function is excluding Fridays and Including Sundays - Help

Hi all,

Having an issue using the WORKDAY function.

Here’s what I’m trying to do:

I’m trying to create training schedule that automatically calculates the date of each training day, based on the start date and the day of training.

EG If start date is Monday Aug 1, 2022 and we’re on training day 5, then the training date should be Aug 5, 2022.

I’ve set the start date for each record to Aug 1, 2022 and the formula works beautifully until I get to training day 5, which should return as Aug 5, 2022. Instead Aug 7, 2022 is returned (a Sunday).

This pattern continues, skipping Friday’s and including Sundays.

Any advice?

It’s probably a time zone issue. I would check the GMT toggle on your date fields.

1 Like

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.