Dates in AVERAGEIF Formula

ViktoriiaKocherha

Hello all!

I need to use formula averageif to count average of duration of projects in weeks, it is bases on the end date of it. I try to do it in Summary of the sheet. Here is the formula but id doesn't work.

=AVERAGEIF([End Date:End Date], [End Date]@row<DATE(2019,12,31), Weeks:Weeks)

It shows that this formula is an invalid operation

Thank you

Heather Duff

Hi @ViktoriiaKocherha

I'm not sure if this will fix your formula completely, but try putting square brackets around each instance of "End Date" - so the formula would read: (I marked the missing brackets in bold)

=AVERAGEIF([End Date]:[End Date], [End Date]@row<DATE(2019,12,31), Weeks:Weeks)

ViktoriiaKocherha

https://community.smartsheet.com/discussion/comment/307344#Comment_307344

Hey, I've tried that, still not working :/ It writes unpareseable.

But thank you