From everything I looked up, I am doing the calculations correctly, but I am still getting data for several days past the "year to date" date. If someone can help, I would be happy to share my workbook. The last fulfilled ship date in the data set is 8/22/23 and the data was refreshed on 8/28/23. I want the previous fiscal year to date data to not go beyond 8/28/23 (the updated date) or at the very least the last ship date that has fulfilled data (8/22/23). but I am ending up with data with a ship date of 9/1/22.
Thank you!
