Pull in Data for Week to Date and Previous Day

[cartica]

HI-

I have attached my spreadsheet. In the first tab (tarding Statistics), this is what I want populated. I was able to fill most of the Month to date data out. I need help with the 2 highlighed in yellow, as well as Week to date (WTD), and Previous day. I am not sure on the formulas to pull from my other tab (eze data). Week to date in this case, would pull in same data as previous date, but if it were Thursday, I would want week to date to pull in Mon-Thurs, and previous day just Thursday.

ThanksMiddle Office Report 1.xlsx

[mike65535]

1) What is a so-called trading day? A weekday? Something else?
2) Are there holidays you need to take into account?

Can you use the function NETWORKDAYS()?

[mike65535]

Assuming M-F are workdays, the number of work days so far in a week =MIN(WEEKDAY(TODAY())-1, 5)

[cartica]

Can you explain that formula? Will that formula produce a number 3 if wed, a 4 if thurs? Also, any ideas on how to pull the data in any of the other cells? Thanks

[mike65535]

Can you explain that formula? Will that formula produce a number 3 if wed, a 4 if thurs?

Yes. Try it!

Replace the TODAY () with a cell (say A1) and in cell A1, put =TODAY() or any date to test.

Also, any ideas on how to pull the data in any of the other cells? Thanks

I don't understand

[cartica]

on tab "Trading Statistics", USD Traded. This would be the sum of tab "eze Data" in column "q". In the Month to date, I just used a sum product formula. What could I use for week to date?