Forum Discussion

NOELHODGES's avatar
NOELHODGES
Qrew Cadet
3 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 before.

------------------------------
NOEL HODGES
------------------------------
Formulas and functions

2 Replies

Sort By
  • MikeTamoush's avatar
    MikeTamoush
    Qrew Commander
    3 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
    ------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    The formula is this

    WeekdayAdd([base date], -15)

    But the result will be 08-30-2022

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------