Using SumProduct for dates inclusive of Year to Date, Month to date, Quarter to Date

**cartica** · 02-26-2014, 10:22 AM

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

**cartica** · 02-26-2014, 01:47 PM

Any ideas?

Thanks

**Tony Valko** · 02-26-2014, 04:22 PM

Remove all the VBA from the file then save it in the *.xlsx format and I'll take a look at it.

Are your quarters standard calendar quarters or are they fiscal quarters?

Using SumProduct for dates inclusive of Year to Date, Month to date, Quarter to Date

LinkBack

Thread Tools

Rate This Thread

Display

Using SumProduct for dates inclusive of Year to Date, Month to date, Quarter to Date

Re: Using SumProduct for dates inclusive of Year to Date, Month to date, Quarter to Date

Re: Using SumProduct for dates inclusive of Year to Date, Month to date, Quarter to Date

Thread Information

Users Browsing this Thread

Similar Threads

Month to Date and Quarter to Date Average from Daily data

calculating month to date, year to date, week to date

Date Range - Start and End Date - Identify dates in a quarter

Formula to calculate the percentage of a year using a start date and year to date dates

Date formula: return Quarter and Fiscal Year of a date

Bookmarks

Bookmarks

Posting Permissions