Forum Discussion

TaraStroup's avatar
TaraStroup
Qrew Member
4 years ago

weekday formula

Hello, 

I have this formula: 

WeekdayAdd([Date],-6) 

When I  run the formula it consistently gives me date -8. 

I am also using date -1, date -2, date-3, date-4 and date-5 and they all work great. Any reason why -6 wouldn't work?

Thanks

------------------------------
Tara Stroup
------------------------------
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    [Date] - Days(6)  will give you the date 6 days ago.

    WeekdayAdd([Date],-6) will give you the date 6 normal Monday to Friday working days ago, which excludes weekends.

     

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------