function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Peter McGavinPeter McGavin 

Please clarify how this formula works in terms of identifying today's day of the week (Advanced Admin - advanced formulas (dates))


CASE( MOD(TODAY() - DATE(1900, 1, 7), 7),
3, TODAY() + 2 + 3,
4, TODAY() + 2 + 3,
5, TODAY() + 2 + 3,
6, TODAY() + 1 + 3,
TODAY() + 3 )