Formula to return a 1 if cell is between two weeks


I just started with Smartsheet 10 days ago and I just want to say this community is great! Up until now I've found the answer for every question I had on this forum.

I'm trying to get DueNext2 to return a 1 if the Due column is within two weeks from today. It isn't working and I've tried everything I know (which is very little). It seems like it should work but I keep getting Incorrect Argument errors. What am I doing wrong?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!