Forum Discussion

TaraTara's avatar
TaraTara
Qrew Member
10 years ago

How do I modify my existing formula date field to exclude weekends?

This is the formula I'm currently using... [Date Entered] + Days(2) It works great. However, right now if the date entered is a thursday or friday it returns a resulting date that falls on the we...
Forms
Formulas and functions
Relationships
EricCirrusOps's avatar
EricCirrusOps
Qrew Trainee
10 years ago
Tara,

You would want to use the 'WeekdayAdd' formula function to solve this. See example:

WeekdayAdd([Date Entered], Days(2))


Hope that helps! Please feel free to reach out to me via my contact info on my profile if you need additional assistance.

Thanks,

Eric