Hot answers tagged

2

I don't know about Swedish but in German you have to use ; instead of , in Formulas. Maybe try that


1

Here is the Form validation formula: =IF(NOT(ISBLANK(DueDate)),IF(DueDate>(TODAY()+(7-WEEKDAY(TODAY(),2)+1+7)),TRUE,FALSE),TRUE) Find days from TODAY() to the first Monday using WEEKDAY(date,return_type), where date is TODAY(), return_type=2. It returns weekdays numbered 1 (Monday) through 7 (Sunday) Add days (step 1) plus 1 to TODAY() to get the first ...


Only top voted, non community-wiki answers of a minimum length are eligible