formula to generate month-to-date based on auto date

Hello-

I am trying to create a formula that would insert month-to-date info based on a auto date formula. Everytime I open my workbook the date of that day shows. I need the month-to-date calculations to be auto generated evertime the workbook is opened, based on the auto date function "=today()"

I have attached an example.

Thank you so much in advance!

Hi

Using your example file sheet summary:
C14: =MIN(IF('Details - 13wk Rolling'!F2:AA2>=B14-DAY(B14)+1,COLUMN('Details - 13wk Rolling'!F2:AA2),""))-1
This is array entered
D14: =MAX(IF('Details - 13wk Rolling'!F2:AA2<=Summary!B14,COLUMN('Details - 13wk Rolling'!F2:AA2),""))
This is array entered.
F16: =SUM(OFFSET('Details - 13wk Rolling'!A15,0,Summary!$C$14,1,Summary!$D$14-Summary!$C$14))
G16: =SUM(OFFSET('Details - 13wk Rolling'!A27,0,Summary!$C$14,1,Summary!$D$14-Summary!$C$14))
Copy from F16:G16 down to row 25.

If you don't want to see the numbers in C14:D14, the select the cells, format, cells, custom, ;;;, OK. This will make the cells not show. Alternatively, put the formulas somewhere that won't interfere with your activities.

rylo