JamesR’s Profile

Community member since March 2015

points
3579
Company
Smarter Business Processes - www.smarterbusinessprocesses.com
Department
Product Development
Area of expertise
Web Forms
How I Use Smartsheet
I am a Smartsheet consultant and assist companies in developing Smartsheets to meet their Business needs, resolve issues and train users.
About Me
Long career in Microsoft Office training, development and consultancy in all Applications to Advanced level including VBA.

6

Hello! 

I'm trying to count the number of children whose "Final Approval Date" is between 6/1/17 and 10/1/17. I don't even know where to start with this formula. I know I've got my weekly totals like this:

=COUNTIF([FINAL APPROVAL DATE]:[FINAL APPROVAL DATE], AND(@cell <= TODAY(7), @cell >