I have a sumifs formula with a date range that is working well. But I would like the formula to change based on the date. So if it's January I want it to pull January 1 thru January 31 and if it's March, March 1 thru March 31st. I have a table that has the dates in it, so is there a way that I can refer to that table and have it do the formula based on that table????
This is an income statement. I can make the table work for YTD, but when I want only the month I have to do a range. What I can't figure out is how to make the range dynamic to change with the different dates without having to manually do this.
Thanks
Bookmarks