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

DV
DV
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.

 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!