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 wor...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legend[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
------------------------------
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
------------------------------