Workday function is excluding Fridays and Including Sundays - Help

Topic Labels: Formulas
515 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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?

1 Reply 1

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