SUMIF Between Dates

[Tyler40]

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)

[Vegar]

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)