SUMIF Between Dates

Tyler40 — Thu, 02 Dec 2021 05:34:22 GMT

Hi there,

I am trying to great a chart that produces the some of hours between two dates. I have the below formula that doesn't show any errors, but doesn't add anything up.

=sum({$ <AnalysisDate={">=$(#=Today()-28)<=$(=Today()-14)"}>} UnitsRostered)

Re: SUMIF Between Dates

Vegar — Thu, 02 Dec 2021 05:54:15 GMT

Make sure you have date within that interval and make sure that you do not have other current selections that is blocking those dates.

I don't think you need the #= to get what you want, try removing it like I've done below.

=sum({$ <AnalysisDate={">=$(=Today()-28)<=$(=Today()-14)"}>} UnitsRostered)

topic SUMIF Between Dates in App Development

SUMIF Between Dates

Re: SUMIF Between Dates