Date Formula that is 15 BUSINESS days before another date field

Question

Hello, I have to create a date formula that is 15 business days before a date field.

So if the user puts 9/20/2022 in a date field, my formula should return 9/9/2022. That would be 15 business days before.

------------------------------
NOEL HODGES
------------------------------

MikeTamoush · Answer

I've never used it but it looks like there is a function for this.

WeekdayAdd (Date d, Number n)

Description: Returns the date that is n weekdays past the given date d. n may be negative to move backward in time.

So: WeekdayAdd([Date Field], -15)

------------------------------
Mike Tamoush
------------------------------

Sign up

Login to the community