Automating Formula to Determine Submissions per Week

07/26/21
Answered - Pending Review

Hello,


I am working on making a sheet that tells me how many submissions we had in a weeks time and want to automate it using two date columns and referencing the intake sheet it is coming from.


I'm currently trying to use the =countifs function and reference the dates next to it but it does not seem to work. This is my current formula: =COUNTIFS({Master Intake Help Column}, "1", {Master Intake Submitted Date}, >=DATE([Week Start Date]1), {Master Intake Submitted Date}, <=DATE([Week End Date]1))


I've attached the sheets at play for reference. Would appreciate any insight! The intake form is the top photo and sheet I am trying to get the formula in is on the bottom. Thanks!


Answers

  • Bassam KhalilBassam Khalil ✭✭✭✭✭

    Hi @samwex 

    Hope you are fine, please try the following formula:

    =COUNTIFS({Master Intake Help Column}, @cell=1, {Master Intake Submitted Date}, @cell >=DATE([Week Start Date]1), {Master Intake Submitted Date}, @cell <=DATE([Week End Date]1))

    PMP Certified

    [email protected]

    www.mobilproject.it

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Sign In or Register to comment.