Formula to calculate two week iteration
Our company works in two week chunks we call iterations. Using the following formula in Excel I am able to calculate what the current iteration is. However when I import from Excel Smartsheet doesn't appear to like the formula.
Using the current date the formula in Excel is
Using a specific date the formula in Excel is
Does anyone know of a way to get these formulas to work?
Help Article Resources
Check out the Formula Handbook template!