Hi-
My sumproduct formula works when I reference one specific date, or when I reference a week time period. How would I change my formula to reference Month to date, quarter to date, year to date? In eze comp p&l tab the date is referenced in in column Q. So, every day it will look like that with a new date. Please help me fill in 1 example in the Trading Statistics tab for MTD, QTD, YTD.
Thankstest.xlsm
Bookmarks