Im sure there is a million of these on here but I have been spinning my wheels on this for a day.
I'm trying to do a year to date formula on a deck tab linked to a large P&L tab. If im looking up March instead of pulling year to date (Jan, Feb, Mar) it is pulling Mar, April, May.
The other issue is im pulling a balance sheet with a month to date and it is pulling other balance sheet cells. Here is the file and the two formulas. I am trying to make this automated so I can change a date in one tab and the whole model works, these are the last issues im having.