Workday diff - including sunday but not friday

[Rob_Fraser]

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?

[ScottWorld]

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