I'm desperately trying to get the pre-built date range filter to work the way I need it to.

Specifically, I have been asked to provide detail for how many project hours are expected to be spent within 30 days for resource allocation. My superior does not use MS project, but rather a crude excel spreadsheet for his own tracking.

No matter how I format the date range, I am given the entire duration of work left to be performed for the entire task. For example, if I have a task spanning 6 weeks, and I am only supposed to provide detail for 30 days, the duration still shows the entire duration, even the hours outside of the 30 days.

Does anyone know of a way to rectify this? I'm at a complete loss.