Weeknumber formula help

Jillian Hodges

I want to count all instances in a weeknumber, but the formula I'm thinking to use is not working and is returning #INVALID DATA TYPE. The 4 is the week number I am looking to count all the instances in.

The reference column is a Date format with nothing but dates in it, so I'm not sure what I am doing wrong, help.

Genevieve P.

Hi @Jillian Hodges

Try wrapping an IFERROR Function around the WEEKNUMBER portion of the formula. It might be trying to read blank cells, which would provide you with that error.

=COUNTIFS({Out Sourcing Entry Date}, IFERROR(WEEKNUMBER(@cell), 0) = [Column2]@row)

Cheers!

Genevieve

Genevieve P.

Hi @Jillian Hodges

Try wrapping an IFERROR Function around the WEEKNUMBER portion of the formula. It might be trying to read blank cells, which would provide you with that error.

=COUNTIFS({Out Sourcing Entry Date}, IFERROR(WEEKNUMBER(@cell), 0) = [Column2]@row)

Cheers!

Genevieve

Jillian Hodges

@Genevieve P. Thanks! That was it!

Genevieve P.

Glad I could help! 🙂