I am needing help with a formula, I have a spreadsheet with "expected ship dates" that I need to create a way to group them by month so I can get a more accurate look at our monthly projected revenue. For example I have 70 line items and each line has a different "expected ship date (ex. 11/8/23, 3/6/24.....) I need a way for this data to translate on my dashboard as monthly revenue based on that "expected ship date"
Help Article Resources
Check out the Formula Handbook template!