Report Help

I am trying to build a report that is looking at one "DATE" column and shows everything that is between 45 to 90 days from today. The trouble I am having is getting it to be dynamic rather than changing the date everyday. Is this possible? Any help is appreciated.

Thanks,

Jason

Find more posts tagged with

Construction

Reports

Comments

Brett Evans

Make a column on the sheet with the formula:

=if(AND(DATE1 < today()-45, DATE1 < today()-90 ), "on report", "not on report")

Jason Rowe

Great Idea. Thanks!

Brett Evans

Play arouind with the greater than/less than. I wrote that without testing.