Automating Formula to Determine Submissions per Week

samwex

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!

Bassam 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))