week

  1. Ramballah

    Year number of week 53

    Hi Everyone, I use a formula that shows yearnumber/weeknumber of a date i get in column A However I noticed that it goes wrong with the year number. See the image above ^: I need this to be 2020/53 since in column C i am using a VLookup function that searches for 2020/53. B5 =...
  2. A

    Identify Week from a date

    Given a date for ex:01/07/2020, is there any way to identify whether it belongs to 1st week of July or sec week?
  3. R

    Weekends no matter the current day

    I am looking for a formula that no matter what today date is it will always return the dates for the following Saturday and Sunday.
  4. U

    Recurring Tasks Calendar

    Hello you all! I've been looking for a way to automate a calendar that I use and as of today I fill it manually. It is a calendar of recurring tasks but they change through the weeks of the year. For example I have tasks that are on mondays every 3 weeks. Others that are monday, wednesday and...
  5. P

    averaging months

    what i want to do is. i want a foumula that will let me to get a rolling average for a month as i add numbers for each week. that total will be in one cell. I want it to be able for it to figure a average for week 1,2,3,4 so that I will have a current average each week. Example: week 1...
  6. E

    Multiple Date Columns in Data Model Pivot Table

    Good Afternoon, How can I create 2 columns with distinct date ranges? I have 1 table with my dates and units and I want to show the units sold for 1 week in 1 column and the next week in the second column and then calculate the change WOW. I don't know how to have two date columns from one...
  7. MCTampa

    Grouping Consecutive Values by Min and Max

    I have the following table for which I would like to create groups of consecutive weeks by min and max values. <caption>Automatics</caption><thead> AREA Code Week </thead><tbody> 330 1 330 2 330 3 330 4 330 33 330 34 330 35 330 36 330 37 330 38 330 39 330 40 330 41...
  8. A

    Add Sequence numbers Based on Dates

    I have one excel file where data is entered, and then transferred to another excel file with macros. On the second excel file I would like a macro that inputs a sequential number for each day in column A, and a sequential number for each week (or Month if week isn't possible) in column B. The...
  9. P

    Minimum If with dates

    Hi, I have a list of weekly dates in Column A and Costs in Column C. I am trying to find the lowest value of C if the date is before this week (as the values constantly go up, using min gives a misleading result as every week starts at £0. My formula (array) is as follows: <k11,c:c,""))[...
  10. L

    Format Control

    I have my format control to change by week stating for 2019 and it runs to week 52 but i want that to change in 2020 to start week 1 thru week 52. Control set to Minimum Value: 44 i started with the data for week 44 Maximum Value: 52 Incremental Change: 1 Page Change: 3 Cell Link: Calculation!$A$2
  11. S

    auto populate

    ok, i'll explain as best I can in d2:s2 I have week numbers in a3:a100 I have part numbers what I am looking to achieve is if I populate (as an example) h15 a formula in c15 will populate with the relevant week number from row 2
  12. HappyChappy

    Barking up the wrong tree

    Hi is it possible I have seven wookbooks stored in numbered week folders each workbook is dated sun01.11.19 to sat07.11.19 . I need to be able to enter the folder name week 45 and each of the seven wookbooks within opened and sheet1 from each be combined into a new wookbook.
  13. F

    Lottery verification

    I have an excel program where I count the numbers for the past year then use the count to pick my lottery numbers. I have won small amounts for the past year every week but never amounts over $100 so now I would like to refine my program to look at the past years drawings and compare it to my...
  14. N

    Power Query - Calendar Table

    Good morning - I have a fiscal calendar that my company creates which I pull into Power BI. Columns include date, fiscal year, fiscal week, day of week, work day, holiday, holiday name, week of month, and fiscal quarter. What I want to do is creat a few custom column in power query that will...
  15. N

    Excel - Summing Up Totals based on a rolling dates

    Good Morning, I would like some help or advice with a basic excel spreadsheet I am to build. On a worksheet I have columns for week numbers and within each week number I am entering values. On another week sheet I have summary sheet where I want to display the current month's week number from...
  16. T

    Help Getting Date on Tab

    Hi, I have a macro that puts data that is in a cell on the tab. Currently I turn the date into Week XX and currently names the tab of the current sheet Week XX. I know you can not put / on the tab. Is there anyway I can Create Week 45 11.3.19 on the tab? I need to replace the / in the date...
  17. P

    Need to calculate Average of first 5 non-zero cells in a ROW

    In this example, each score is entered for only the players that played this week leaving lots of blank cells. A new column is added each week between Column D(Hidden) and E. I did this so the arrays in formulas will automatically update when a column is inserted inside the array. In Column...
  18. C

    Count Days Between Two Dates

    I thought this would be simple but my attempts are not working for me. I need two things PLEASE. I am trying to calculate the total number of "days" between two dates, and secondly, calculate the number of "week days" between the same dates. Each would be in a separate cell. I am totally...
  19. L

    How to automatically update excel without opening it once per week

    Hi, Right now, once a week I need to open a file, refresh the table, save and close the file. Is it possible for excel to automatically update itself without opening it once per week? Thanks in advance.
  20. S

    Partial Weeks

    I am trying to create a formula or script that will identify partial weeks. The end goal will be to yield if a month ends in the middle of the week I want to have the week start date be the same and the end of week be the last day of the month and the start of the next month be the first day of...

Watch MrExcel Video

This Week's Hot Topics

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
Top