Forum Discussion

laharms's avatar
laharms
Qrew Member
3 months ago
Solved

Adding number of Business Days to Date

Hello, I want to add 25 business days to a starting date and get an end date. I know how to do it with all days but I need business days. Please help! ToDate([Date Requested]) + Days(25)  
formulas
  • MarkShnier__You's avatar
    MarkShnier__You
    3 months ago

    Try this

    WeekdayAdd([Date Requested], 25)

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 months ago

Try this

WeekdayAdd([Date Requested], 25)

laharms's avatar
laharms
Qrew Member
3 months ago

I tried that but it's saying [Date Requested] needs to be a number, not a date. 

  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 months ago

    Is your formula field type a formula date. Can you post a screen shot of the error when you save?