Hello, I have a button that creates 12 month sheets for a specific year that is entered into an inputbox. The code below enters values (coming from a master sheet list) randomly every workday per month sheet created.
I would like to have only unique random values per week, and a minimum of 2...
I currently have an email macro in VBA that looks like this (important parts only):
Basically, I click on a macro and it sends out an email to the emails listed in certain cells. However, the message that the email depicts has been written in VBA with the .HTMLBody code.
I'm sure this is an easy one, but I've scoured the internet for an answer and can't find one for my particular scenario.
I'm looking for a formula that will return the first and last day of the week with the first of the month being the start date and the first Saturday being the last day...
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.