Want to Calculate Crew Required Based on Specific Dates

SOC Compliance

Below is the screenshot of the formula I am trying to use but it always returns 0, Please guide Thanks!

12.png

Megan Ryzenga

Hi @SOC Compliance !

Try this:

=SUMIF([Start Date]:[Start Date], =DATE(2022,2,1), [Total Crew Required]:[Total Crew Required])

Heather Duff

Hi @SOC Compliance ,

I may be oversimplifying this, but have you tried using "2022" instead of "22" as the year within your date? I haven't ever tried just using the two-digit year, so I'm not sure how it works.

Let me know if that fixes it!

Best,

Heather

SOC Compliance

@Heather Duff Sorry friend but this does not work

Megan Ryzenga

Hi @SOC Compliance !

Try this:

=SUMIF([Start Date]:[Start Date], =DATE(2022,2,1), [Total Crew Required]:[Total Crew Required])

SOC Compliance

@Megan Ryzenga Thanks You are a life saver :)