week to date

  1. H

    CUME Week to date formula

    Hello, I have a table of data, in the first column is the week i.e Week 1, Week 2 etc. In the second column i have fully populated with last year sales data by week. in the final column i have this year data which every Monday is updated. I have this setup for many departments and each week i...
    • horkstar12
    • Thread
    • formula to count cells formula to find data if function week to date
    • Replies: 9
    • Forum: Excel Questions
  2. C

    Question: Sum product weekly averages?

    Can someone please help me modify this sum product average formula (currently for months) - to calculate weekly averages? =SUM(IF(FREQUENCY(IF((ROUNDUP(MONTH($A$2:$A$100)/3,0)=MID(AG$4,2,1)+0)*(YEAR($A$2:$A$100)=VALUE(RIGHT(AG$4,4)))*($C$2:$C$100=AG$5),MONTH($A$2:$A$100)),{1,2,3,4,5,6,7,8,9...
  3. B

    Week To Date and MTD Calculations

    Hi All, I need some help on a calculation - I have a table full of data that I'm building a report on - This report will have Previous Day, Week To Date, and Month To Date calculation. How do I create calcs in the report so that it automatically pulls the Week to Date and Month to date calcs...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top