Formula to indicate previous and next months
I'm drawing a blank on how to achieve something to avoid having to manually maintain a sheet.
I've got a main data sheet with new requests getting populated. They have dates associated with them and what I'm doing is pulling them into another sheet to summarize that data based on the month. This piece is working great with the formulas calculating for how many were created in a month, due in a month, and completed in a month.
The piece I need help with is how I can automatically adjust based on the current date and update surrounding cells to use a date in the previous 5-months and next 4-months to show how things have gone and what the forecast is looking like without having to manually adjust any of the data to keep the related Dashboard Graph current.
Help Article Resources
Check out the Formula Handbook template!