+ 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 )