Hi
I am stuck and need some help please. I have attached a picture of the issue i am having. Basically i have 7.5% in the red box (Cell B2) that i have to update manually. I would like it to auto update each Tuesday of the month with the same % as the week before (orange box's) but if say on...
I have tried to find the answer but maybe I’m just not wording my query well enough to find the answer, apologies if this has already been asked.
Scenario: spreadsheet filled with birthdates, we decorate person’s office/desk the entire week of birthday, with a cupcake the day of.
There is...
🤓 Good day my fellow nerds,
Today I need guidance on how to figure out the Week Number based on the day.
Let me breakout a list of things you will need to know:
- The Week # being displayed will be based on the United States Government Fiscal Year 2023 which is: 1st quarter: 1 October 2022 –...
Hi. I want to create a weekly project tracking.
This is the step:
1. User enter the required date to fill in the data
2. The formula will automatically display the required week and Monday date
3. User key in project, start, end, status and manager
The problem is:
Assume after filling the data...
I need help figuring out how to calculate employee's extra earnings due to extra hours they worked each week.
Let's say, the year starts on November 1st. So the first week of November starting Sunday and ending Saturday is Week #1 (if November 1 starts on a Friday, then Week #1 will consist of 2...
I want to generate a special excel formula. My wish is to find out the last working day of each week. Thus, the formula is designed to analyze consecutive dates and find all Fridays, or, if there is no Friday for a given week, the last working day in the same week before Friday. The Friday or...
Hello,
I am trying to create a custom week number formula where week starts on Saturday and ends Friday. The fiscal year starts from 02/01/2018 and ends on 01/31/2019
** This how i want week number list to start and end.
The three columns, first column shows week number, second showing...
I want to calculate monthly values from weekly ones, by taking into account the number of days in the weeks that overlap each month.
Below is an example. Row 5 shows the figures I want to calculate, by referencing the rows above.
<tbody>
03/05/2015
10/05/2015
17/05/2015
24/05/2015
31/05/2015...
Sorry if I don't explain this very well, I'll do my best-
I need a formula in B1, which will check the date in A1 and tell me if it is within this week's dates. It will say 'This Week' if this is true. (eg. if A1 says: '30/12/2014' (or any other date from the current week) then it will say...
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.