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.
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...
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.
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...
I have the following table for which I would like to create groups of consecutive weeks by min and max values.
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...
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:
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
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
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.
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...
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...
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...
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...
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.
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...
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.
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...