Newbie: trying to return cell contents if date is less than and greater than...

edited 12/09/19 in Formulas and Functions

I'm new at this.

Let's say these are my three columns:

Open Balance | AR Due Date | WK 1


So in the WK1 cell I want this formula:

If the AR Due Date is greater than 01/01/2018 and less than 01/07/2018, then return the value of Open Balance.

I've tried, but keep getting errors. Thanks for your help.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!