Same Formula Giving Error in Different Cells

kira11

Hello,

I have a formula that should be the same for all three calculations I am trying to do but two are giving an error when I think everything about them is the same.

Here are the two formulas I am using:

The Insp Date produces a number/no error and the Weld Date produces #INVALID DATA TYPE. The are in the same column on my metrics sheet I am using to write the formulas and they are both 'Date' type in the source sheet.

I am getting #INVALID DATA TYPE for a third cell/calculation that is exactly the same as the example above. I cannot figure out why it is working for one and not the other two, any help would be greatly appreciated!!

Paul Newcome

It sounds like you may have blanks in the source data which would throw that error on the WEEKNUMBER function which would in turn push through as the formula output. Try this instead:

=COUNTIFS({Date Range of Choice}, IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER(TODAY()))

Paul Newcome

It sounds like you may have blanks in the source data which would throw that error on the WEEKNUMBER function which would in turn push through as the formula output. Try this instead:

=COUNTIFS({Date Range of Choice}, IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER(TODAY()))