Forum Discussion

NOELHODGES's avatar
NOELHODGES
Qrew Cadet
4 years ago

Date Formula that is 15 BUSINESS days before another date field

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...
Formulas and functions
MikeTamoush's avatar
MikeTamoush
Qrew Commander
4 years ago
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
------------------------------